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!