Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Indexing an Array with VLOOKUP
Hi, I have an array with multiple occurrences of my lookup value that I would like to summarize in another table. Is there a way to index to the next occurrence of the lookup value once vlookup has found the first occurrence? Appreciate any help, Joe |
#2
|
|||
|
|||
One way:
=INDEX(B1:B10,SMALL(IF(A1:A10="X",ROW(B1:B10)),N)) Array-entered (press ctrl + shift + enter), whe B1:B10 = range that contains value to return A1:A10 = range to search for lookupvalue X = lookup value N = positive integer representing nth occurence (e.g., 2 = 2nd occurence, if there is one) HTH Jason Atlanta, GA -----Original Message----- Hi, I have an array with multiple occurrences of my lookup value that I would like to summarize in another table. Is there a way to index to the next occurrence of the lookup value once vlookup has found the first occurrence? Appreciate any help, Joe . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Vlookup and Indexing in excel | Excel Worksheet Functions |