Hello all,

I think I have a good one today

I have two sheets

SHEET 1, SHEET 2

Both sheets share 5 columns that are identical with the same headers at the top.

A, B, C, D, E

Goal:

Formula in Cell E of SHEET 2
Reference Cells (A,B,C,D) in the same row
Check(index) SHEET 1
Find row that contains the same data that is referenced in (A,B,C,D) from SHEET 2
And return with the value Cell E of SHEET 1 in Cell E of SHEET 2.


EXAMPLE:

SHEET 1

Column A Column B Column C Column D Column E
1 DOG CAT MOUSE Tomato Building
2 DOG CAT MOUSE BEAR Cup
3 DOG CAT MOUSE CARROT Bread
4 DOG CAT MOUSE PEAR House


SHEET 2:

Column A Column B Column C Column D Column E
1 DOG CAT MOUSE CARROT FORMULA


Formula will look at SHEET 1, find the row that matches Columns (A,B,C,D) which in this case would be row #3 and return and show "Bread" in Column E of SHEET 2.

I hope that makes sense, I used to doing simple INDEXINGS formulas but never multiple cells as a reference index.