Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can anyone tell me how to get the match and index functions to work for an
8x8 table? So for example I would like the function to take a given text string ec for example, search for its position in the first table, then look at the second table and return the value the corresponds to the text string located in the first box. Examples - I ask the function to find the value corresponding to; ec the function returns the value 99, for bh - 4, for ga- 78. The text string to match is in cell m10, and the top left corner of the tables begins in cell N10. Tables below a b c d e f g h a aa ba ca da ea fa ga ha b ab bb cb db eb fb gb hb c ac bc cc dc ec fc gc hc d ad bd cd dd ed fd gd hd e ae be ce de ee fe ge he f af bf cf df ef ff gf hf g ag bg cg dg eg fg gg hg h ah bh ch dh eh fh gh hh a b c d e f g h a 20 11 30 33 44 40 78 54 b 20 20 20 20 20 20 20 20 c 20 43 5 90 99 67 60 56 d 20 20 20 20 20 20 20 20 e 20 20 20 20 20 20 20 20 f 20 20 20 20 20 20 20 20 g 20 23 21 12 12 12 12 12 h 20 4 4 4 4 50 43 80 Anyone know? I can't figure out how to get match to look at tables rather than columns. Thanks a million |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |