Excel Formula

[oRie]

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?

[Pecoflyer]

Hi
could you please post a sample file? Thx

[JBeaucaire]

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.