help with vlookup formula!

AliH

New member
Joined
Dec 18, 2013
Messages
1
Reaction score
0
Points
0
Hi there,
I have a problem I’m trying to fix in Excel 2010.
Basically I need to look up a value from one spreadsheet page to see if it exists, and then copy the information from and adjacent cell on the same row.
So, sheet “Source” has two columns, listing a product code (Col A) and product details (Col B).
In the “Display” sheet we have a list of product codes (Col C), and a space to display the detail (Col D).
I therefore need to:
· take a product code from Display (in Col C),
· look it up its matching row on Source,
· pick up the detail on Col B, and
· display it in Col D.
Hope this makes sense.
Can anyone help?
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
You can use vlookup. In D2:

=vlookup(c2,Source!A:B,2,FALSE)

And drag down.

Best of luck,
 
Top