vlookup everything

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a range of data a1:ep1
i have vlookup(ev1,a1:ep1,2)
however i also need vlookup(ev1,a1:ep1,3)..4,5,..120
is there another function that will look up the value in a1 and return
everything in that row?
 
Hi
select your target range and array enter (with CTRL+sHIFT+ENTER):
=vlookup(ev1,a1:ep1,{2,3,4,5,6,7,8,9})

just make sure the ranges match
 
choice said:
i have a range of data a1:ep1
i have vlookup(ev1,a1:ep1,2)
however i also need vlookup(ev1,a1:ep1,3)..4,5,..120
is there another function that will look up the value in a1 and return
everything in that row?
Click to expand...
There's obviously something you're not telling us. The value in a1 and
ev1 don't really have anything to do with returning everything to the
right of a1.

=B1:EP1, array entered into a long enough row of cells (e.g., A2:EO2),
will do it.

Alan Beban
 
Back
Top