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?