| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confusion with INDEX & MATCH
I have a list of numbers on sheet 1 and need to add a code in the next column.
On sheet 2 the first column has the codes, and the next 30 columns have numbers. I created named ranges for the first column as "mealtable" and the next 30 columns as "lookupvalueh". I tried the following formula without success: =INDEX(MEALTABLE;MAX(ROW(MEALTABLE)*(B20=LOOKUPVAL UEH));) B20 is the value I want to look for in the table, bringing back the code from the first column of the row with the value in. any help in putting me on the right track would be appreciated. As you can see I am not an expert, but work on trial and error. I did press control shift & enter to put the formula in brackets. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
