Looking up ...

[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)

 

[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))