Looking up ...

D

Dennis

I have a table of information. in one column, I have
fund numbers that can occur more than once. Is there a
way to do a vlookup or other formula, but pull
information from the second time or third time the fund
number appears? (without using macros)
 
F

Frank Kabel

Hi
try an array formula liek the following (entered with
cTRL+SHIFT+ENTER):
=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=fund_number,ROW($A$1:$A$100)),o
ccurence))
 
Top