H
Hardeep kanwar
Hi! All
I have data in Sheet 1like
Its a code
5848606
9659285
8100949
4846771
7201303
And in Sheet2 i have master Sheet. Data Range A1:Z600
Now i want to Pickup the Data From Sheet 2 i.e B2 to Z2 to Sheet1
I use VLOOKUP(A1,Sheet2!a2:b600,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(A1,Sheet2!a2:b600,2,false)
VLOOKUP(A1,Sheet2!a2:c600,3,false)
VLOOKUP(A1,Sheet2!a2:d600,4,false)
VLOOKUP(A1,Sheet2!a2:e600,5,false)
And so on
Thanks in Advance
Hardeep kanwar
I have data in Sheet 1like
Its a code
5848606
9659285
8100949
4846771
7201303
And in Sheet2 i have master Sheet. Data Range A1:Z600
Now i want to Pickup the Data From Sheet 2 i.e B2 to Z2 to Sheet1
I use VLOOKUP(A1,Sheet2!a2:b600,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(A1,Sheet2!a2:b600,2,false)
VLOOKUP(A1,Sheet2!a2:c600,3,false)
VLOOKUP(A1,Sheet2!a2:d600,4,false)
VLOOKUP(A1,Sheet2!a2:e600,5,false)
And so on
Thanks in Advance
Hardeep kanwar