Try to match cells and return values

Closed
Paulie462 - Dec 23, 2010 at 09:09 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 9, 2011 at 04:40 PM
Hello,

I need help!!

I have a table containing the following:

Column A Column B Column C Column D
product Country State Date

I have a second table containing all the Column A and B product and conutry details. I need to compare Columns A and B of the table above to my table, if it matches then look at column C. Depending on the data in C then return the value in column D to my table.

Hope this makes some sort of sense and that someone can help.

Thanks,

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 9, 2011 at 04:40 PM
looks like you need to use VLOOKUP
0