vlookup everything

[choice]

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?

 

[Frank Kabel]

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

 

[Alan Beban]

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?

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