How to merge 2 vlookup formula in a cell.

[Jagdev Singh]

Hi Experts,

I have 2 data sheets and a mastersheet. I need to compare the data from 2 data sheets with the data available in the master sheet.

Current I am applying 2 vlook-up formula in different columns of the master sheet.

=VLOOKUP(D:D,'[LPSO -12 12 14.xls]Sheet1'!$J:$Y,16,FALSE)
=VLOOKUP(D:D,'[IUA - 12 12 14.xls]Data'!$H:$U,14,FALSE)

Could you please help me to create a single formula which will pull data from both the data sheets into a single column of the mastersheet.

Regards,
Jaggi

 

[rrocker1405]

Hi jagdev,

It would be easier if you can share a sample workbook and point out where the formula is.

Kind regards,
Anand

 

[Jagdev Singh]

Hi Anand

Thanks for looking into it.

=VLOOKUP(D:D,'[LPSO -12 12 14.xls]Sheet1'!$J:$Y,16,FALSE) / column E of the master sheet
=VLOOKUP(D:D,'[IUA - 12 12 14.xls]Data'!$H:$U,14,FALSE) / Column F of the mastersheet.

These formulas are pulling the required data out of the respective sheets into Column E and F as per my above explanation.

What I am looking for is to merge both the formulae into one and instead of using it in 2 different column can I have the result in a single column.

Regards,
Jaggi

 

[Somendra Misra]

@Jagdev Singh

Can you upload a dummy file with some data (sample) with the same formula working.

Regards,

 

[alacrity59]

Hi Experts,

I have 2 data sheets and a mastersheet. I need to compare the data from 2 data sheets with the data available in the master sheet.

Current I am applying 2 vlook-up formula in different columns of the master sheet.

=VLOOKUP(D:D,'[LPSO -12 12 14.xls]Sheet1'!$J:$Y,16,FALSE)
=VLOOKUP(D:D,'[IUA - 12 12 14.xls]Data'!$H:$U,14,FALSE)

Could you please help me to create a single formula which will pull data from both the data sheets into a single column of the mastersheet.

Regards,
Jaggi

It may be as simple as:
=IFERROR(VLOOKUP(D:D,'[LPSO -12 12 14.xls]Sheet1'!$J:$Y,16,FALSE),"")&IFERROR(VLOOKUP(D:D,'[IUA - 12 12 14.xls]Data'!$H:$U,14,FALSE),"")

 

[Jagdev Singh]

Hi Alacrity,

Thanks for the formula. It fetch the result I was looking for.

Happy New Year!

Regards,
JD