Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with UDF to search through a table | Excel Worksheet Functions | |||
Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
need to search a table such as distance table in road maps. | Excel Discussion (Misc queries) | |||
Using [bold] as a criterion to search | Excel Discussion (Misc queries) | |||
search from a data table | Excel Discussion (Misc queries) |