| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell identification for a 'lookup'
Hi again
Sorry, I didn't see that the return value is in column left to lookup column. The VLOOKUP needs the lookup column to be leftmost in lookup range. You have to redesign your sheet, or you have to use more complex formula, like =INDEX($A$1:$A$1000,MATCH(MAX($B$1:$B$1000),$B$1:$ B$1000,0),) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
