Vlookup Multiple Cells?

[Steve Almond]

I want to use Vlookup to obtain the first 5 cells to the right of the
'Lookup Value' in the 'Table Array'.
I know I can do this with 5 different Vlookup functions, but is there a way
to 'Lookup' a range of cells?

Steve

 

[Peo Sjoblom]

One way

=VLOOKUP(A1,$B$1:$G$100,{2,3,4,5,6},0)

you have to select 5 cells across, then click in the formula bar and enter
the formula there, and then enter
the formula with ctrl + shift & enter

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[JE McGimpsey]

One way:

Select 5 cells in a row and array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=VLOOKUP(Lookup_Value,Table_Array,{2,3,4,5,6},FALSE)

 

[Steve Almond]

Folks,

That's excellent, thankyou.

Steve

One way:

Select 5 cells in a row and array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=VLOOKUP(Lookup_Value,Table_Array,{2,3,4,5,6},FALSE)