Vlookup

[ristanto]

i understand that using vlookup . ur allowed to retrieve certain data
My question is whether can data with more then 1 entries be retrieved.

an example :

I search for 2000 and under that 2000 there are 2 users. can i retriev
both user details?

 

[Frank Kabel]

Hi
you may use the following kind of array formula (entered with
CTRL+sHFT+ENTER)
=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100="username",ROW($A$1:$A$100)),RO
W(1:1)))
and copy this down as far as needed