View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AusTexRich AusTexRich is offline
external usenet poster
 
Posts: 11
Default Search a table using three criterion

I've tried it all it seems, Index, match, and/if statements. I'm done.

I have a data table with seven columns and thirty rows.

On the same sheet to the right of the table I've got an input form with
three data validation cells in a row. I want to match the data in the three
input cells with the data in a row in the table and when the three match a
row from the table return the cell contents found in the last column of the
table.

Table Input area
A B C D E F G I J
K L
1 d1 d2 d3 d4 d5 d6 d7 d1 d3 d5 d7
2 x2 x3 x4 x5 x6 x7 x8 x2 x4 x6 x8

I'd appreciate any help.
--
AusTexRich