A
AusTexRich
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.
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.