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?
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?