| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Vlookup based on designated occurrence of value
Ron Coderre wrote...
Using your data in cells A1:B6 . . . D1: Red D2: 3 D3: =INDEX($B$1:$B$6,MATCH($D$2,--COUNTIF(INDIRECT("$A$1:$A$"&ROW(1:6)),$D$1),0)) .... You could use a shorter formula that avoids volatile function calls. =INDEX($B:$B,SMALL(IF($A$1:$A$6=$D$1,ROW($A$1:$A$6 )),$D$2)) Also an array formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif based on vlookup array | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Vlookup based on two lookup values | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Threaded Mode
