Vlookup

  • Thread starter Thread starter ristanto
  • Start date Start date
R

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?
 
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
 
Back
Top