Search results

Thanks Luke - worked perfectly! Jason - I used the fruit combos as a simple example, but in practice my sheet1 one is constantly being refreshed with new data and I need it to look up the values that are assigned to the combinations on the back end.

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)...