Multiple Columns Using VLOOKUP

[hardeep.kanwar]

Hi! All

I have data in Sheet 1 i.e A1:A20000 like mentioned Below

Its a code

5848606
9659285
8100949
4846771
7201303

And in Sheet2 i have master Sheet. Data Range A1:Z45000

Now i want to Pickup the Data From Sheet 2 i.e B2 to Z2 to Sheet1
Right now i am using =VLOOKUP(A:A,Sheet2!A:B,2,false)
It Work Fine for me .

Is it possible to use only one Formula

Or i have to type one by one Vlookup Formula to pickup data from column in
sheet2 Like :

VLOOKUP(A:A,Sheet2!A:B,2,false)
VLOOKUP(A:A,Sheet2!A:C,3,false)
VLOOKUP(A:A,Sheet2!A:D,4,false)
VLOOKUP(A:A,Sheet2!A:E,5,false)
And so on

Thanks in Advance

Hardeep kanwar

 

[c_m]

Try:
=VLOOKUP(A:A,Sheet2!A:Z,COLUMN(),FALSE)
assuming that you are punching the first formula in B1 of Sheet1

 

[Aladin Akyurek]

Is the data on Sheet2 sorted in ascending order on column A? If that's the case, you can set up a faster scheme for retrieval.

Otherwise:

Sheet1

B1, copied down:

=MATCH(A1,Sheet2!A:A,0)

C1, copied across and down:

=IF(ISNUMBER($B1),INDEX(Sheet2!B:B,$B1),"")

 

[hardeep.kanwar]

Wow,

Works Like a Magic

Thanks Aladin

Hardeep kanwar