Function Help

[Fellow Wanderer]

I have a large amount of data with unique values in a column from which I
need to find a specific value and then return the value in the same from a
different column.

For example, in the below table, if I have the value 204 I would like to
receive the result "Blue".

A B C
1 201 Apples Red
2 202 Oranges White
3 203 Pears White
4 204 Grapes Blue
5 205 Bananas Red

Any help would be greatly appreciated!

 

[Max]

One way
In F1: =VLOOKUP(E1,A:C,3,0)
where E1 contains the value to be looked up, eg: 204
Copy F1 down

 

[Fellow Wanderer]

Thank you for the help! I thought about it right after I posted (and left
the office), and felt silly for asking

 

[Max]

No prob, welcome. It would benefit other readers.
Do take a moment to press the "Yes" button below though.