Hi,
I am trying to figure out a formula to look at Value1 in Column A and Value2 in Column B, and then look up Value3 in a table where Value1, Value2, and Value3 are listed. Kind of confusing to say, but here's an example:
Column A (sheet 1)
Apples
Apples
Oranges
Column B (sheet 1)...