| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX & MATCH find first column value in an array?
I need to lookup a value in cell D15 from worksheet B in an array found in
worksheet A for the first column containing the value of cell D15 from worksheet B. Within one column of worksheet A the value of cell D15 may exist more than one time. I need the function to return the value in row 2 of this column. I have tried using this "=INDEX('WorksheetAARRAY',MATCH(D15,'WorksheetAARR AY',0),1) but this only works if Match is one column or one row. It is not possible to up the sheet this way. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula with index + match | Excel Worksheet Functions | |||
| Help with an Index Match Array | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Index and Match Array formula | Excel Worksheet Functions | |||
| Array index, match problem | Excel Worksheet Functions | |||
Threaded Mode
