Trace a column to check for matches.

**Ayra** · 05-29-2013, 12:20 PM

Hi,

I have a problem with one assignment:

I have a table which contains a column with product codes "Product CODE" and related to it other columns with price and so on.
I need to fill up in a different cell (that not belongs to the table), a product code, and I expect Excel to trace the "Product CODE" for matches. If there is any, it has to extract the related to the matched cell price and so on.

What would happened if there is more than one record with the same value in the traced column?

See the attached file.

http://s21.postimg.org/smso6fn9z/Excel_question.jpg

\1

\1
image hosting over 2mb

Thanks in Advance
Ayra

**Pepe Le Mokko** · 05-29-2013, 02:32 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic