# Comparing columns and returning value

Solved/Closed
ll - May 27, 2009 at 03:08 PM
kittu - Apr 14, 2017 at 01:58 AM
Hello,

I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column.

EX:

```Column: A     B     C     D
1     1     Z      Forumula: return value
1     2     Y
1     3     X
1     4     W
2     5     V
2     6     U
2     7     T
3     8     S
3     9     R ```

What I would like to happen in column D is for it to look at what is in column A, find the matching value in column B, and return the value listed in C. i.e. for any value of '1' in column A, I would want column D to display 'Z', for any value of '2' in column A, I would want column D to display 'Y', for any value of '3' in column A, I would want column D to display 'X', etc.

Could someone help?

Thanks!
Related:

## 12 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
May 28, 2009 at 02:27 AM
Hi

Use the formula (in cell D1) =VLOOKUP(A1,\$B\$1:\$C\$9,2,FALSE)
Do let me know If it helps...
Thanks so much, the VLOOKUP formula worked! I wouldn't have figured it out on my own... I think I understand it, but not sure what the '2' does in the 2,FALSE part of the formula. If you'd like to explain, that'd be great, if not, you've helped enough and saved me hours of work!

Thanks!
Thanks folks, it really is helpful...
Keep up the good work
OMG this formula has just saved me from tearing my hair out, THANK YOU!
ballin out - very simple formula, thank you for helping
Thanks