VLOOKUP help across worksheets

[Gnome]

Hey all,

currently trying to combine some text together from multiple worksheets based on VLOOKUP

what I have so far, only returns the first valid result to the cell with the formula - how can I combine the results?

My formula is =IFERROR(VLOOKUP(Raw!A1,Sheet2!$A:$F,4,)IFERROR(VLOOKUP(Raw!A1,Sheet3!$A:$F,4,)IFERROR(VLOOKUP(Raw!A1,Sheet4!$A:$F,4,))))

This currently skips sheet2 which is empty (intended), captures the data in sheet3 but stops there and does not capture the data in sheet 4.

I'm using Excel 2010, should probably also mention, this will likely extend to further worksheets in time

 

[Sufiyan97]

Hi & Welcome to MrExcel.

This currently skips sheet2 which is empty (intended), captures the data in sheet3 but stops there and does not capture the data in sheet 4.

It is because when it finds the result in sheet 3 it will not go to sheet 4
if it will not find the result in sheet 1,2 and 3 then and then it will look in sheet 4


if you want to combine all the results

May be try

=IFERROR(VLOOKUP(Raw!A1,Sheet2!$A:$F,4,),"")&" - "&IFERROR(VLOOKUP(Raw!A1,Sheet3!$A:$F,4,),"")&" - "&IFERROR(VLOOKUP(Raw!A1,Sheet4!$A:$F,4,),"")

 

[Gnome]

Hi & Welcome to MrExcel.


It is because when it finds the result in sheet 3 it will not go to sheet 4
if it will not find the result in sheet 1,2 and 3 then and then it will look in sheet 4


if you want to combine all the results

May be try

=IFERROR(VLOOKUP(Raw!A1,Sheet2!$A:$F,4,),"")&" - "&IFERROR(VLOOKUP(Raw!A1,Sheet3!$A:$F,4,),"")&" - "&IFERROR(VLOOKUP(Raw!A1,Sheet4!$A:$F,4,),"")

ah - worked perfectly - thankyou!

 

[Sufiyan97]

ah - worked perfectly - thankyou!

You're welcome!
Happy to help.