Vlookup Multiple Cells?

S

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
 
P

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
 
J

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)
 
S

Steve Almond

Folks,

That's excellent, thankyou.

Steve


JE McGimpsey said:
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)
Click to expand...
 
Top