Single solution instead of Multiple Vlookup

[nbkjytr]

Hello Everyone,

I work on a report where I have take certain set of data from different excel file for this I use Vlookup. All the information are available in the same excel file but for every column to get the desired outcome i have write down the whole Vlookup formula on every column. Just want to know if we have any shortcut for Vlookup where i can write the formula just once and get the outcome in multiple columns.

 

[BigBeachBananas]

Sample dataset?

 

[Peter_SSs]

It would help if you could give us a small set of dummy sample data and the expected results with XL2BB

 

[nbkjytr]

Sample dataset?

Attached is the screenshot, I need to Vlookup the data from Excel 1 to Excel 2, and for every column currently I have to write the whole Vlookup formuale in all the cells and then drag it down to the last data set. Need a solution where i dont have to type the formula again and again.

 

[BigBeachBananas]

Try enter this is K3 and autofill down

=INDEX(B:H,MATCH(J3,A:A,0),0)

 

[Peter_SSs]

For the layout in that image, try this in cell K3 and copy across and down.

=INDEX(B$3:B$100,MATCH($J3,$A$3:$A$100,0))