Function Help
 

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!

Function Help
 

One way
In F1: =VLOOKUP(E1,A:C,3,0)
where E1 contains the value to be looked up, eg: 204
Copy F1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fellow Wanderer" wrote:
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!

Function Help
 

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

"Max" wrote:

One way
In F1: =VLOOKUP(E1,A:C,3,0)
where E1 contains the value to be looked up, eg: 204
Copy F1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fellow Wanderer" wrote:
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!

Function Help
 

No prob, welcome. It would benefit other readers.
Do take a moment to press the "Yes" button below though.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fellow Wanderer" wrote:
Thank you for the help! I thought about it right after I posted (and left
the office), and felt silly for asking :)