Hey guys.
Having issues with excel and it appears to be really easy but I just can’t seem to figure it out. I’m not the greatest with excel but though I’d be able to handle this...
Basically I have a table with 3 columns of data. I have another spot where there will be 2 parts of that data inputted and I want it to pull the third piece of data from the table. The issue is there are multiple data points with the same value in one column.
Blue. 2. Cow
Blue. 3. Monkey
Blue. 4. Dog
Green. 5. Cat
Green. 6. Fish
Green. 7. Horse
Basically I would have the colour and number in a table and then I want it to pull the animal name automatically.
Any help is appreciated.