Hi all!

I've run into a particular formula that I cannot seem to come up with. My issue is:

I have a file called "Test" that contains 2 worksheets. Sheet1 and Sheet2.

Sheet1 contains 4 different columns. Sheet2 contains only 3 columns.



I need to compare a long list of entries on Sheet1 located in Column B and Column C to entries located on Sheet2 in columns A and B.

IF Column B and C on Sheet1 match Columns A and B on Sheet2 THEN output column C located on Sheet2 to Column D on Sheet1.

I have absolutely no idea how to go about accomplishing this. Anyone have any ideas?

Hi
could you please post a sample file? Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

1) On sheet1, put this formula in D1, then copy down... you will get errors on the non-matches....

=INDEX(Sheet2!$C$1:$C$200, MATCH($B1&"-"&$C1, INDEX(Sheet2!$A$1:$A$200&"-"&Sheet2!$B$1:$B$200, 0), 0))

2) Copy that column

3) Do an Edit > Paste Special > Values to remove the formulas

4) With the data still highlighted, press F5 and click on Special

5) Select Constants > Errors > OK

6) Press DELETE and the error cells will be gone.