PLS Help me to Vlookup..

[iRasim]

Is it possible vlookup automatically?
As in picture in cell c2 I write vlookup to get data from k2.
I want to know if it is possible to make cell d2, e2 and f2 make vlookup automatically to get data from right side? I mean if I write in a cell vlookup formula others make it automatically?

 

[kchiba]

hi iRasim,

you can do that by putting an array as follows:

=VLOOKUP(B2,$J$2:$N$200,{2,3,4,5},0)

the formula must be entered as an array with Ctrl, Shift and Enter

cheers
kanti

 

[Xiq]

Or a non-array formula like:

=VLOOKUP($B2,$J$2:$N$200,COLUMNS($B$1:C$1),0)

Place in C2 and replace the comma's with semicolons or see attached file.

 

[sgmpatnaik]

@iRasim

another approach try this

place the formula in C1

=VLOOKUP($B2,$J$2:$N$200,K$2,FALSE)

and drag to right side