Vlook up from Mutiple Sheets

Simone Hampton

Hi All,

I need to do a vlook up against a unique code, from a production plan - dates, QTYs etc.

However, I have a live 1. Sheet Plan and I have a 2. Sheet archieved plan. I need to do a vlook up from the 2 sheets into a 3 sheet.

Please if someone can help with the formula.

Formula below works fine for one sheet.

=VLOOKUP([Unique code (Plan)]@row, {New Production Plan Range 1}, 25, 0)

This is what i have tried for 2 sheets

=VLOOKUP([Unique code (Plan)]@row, {New Production Plan Range 1}, 25, 0) * (VLOOKUP({Production Plan - Completed / Archived Range 1}, 22, 0))

I have also tried this

=IFERROR(VLOOKUP({Production Plan - Completed / Archived Range 1}),22,0),VLOOKUP({New Production Plan Range 1},25,0)

Appreciate any help.

Cheers Sim

VBAGuru

This has an extra ')' at the end

=VLOOKUP([Unique code (Plan)]@row, {New Production Plan Range 1}, 25, 0) * (VLOOKUP({Production Plan - Completed / Archived Range 1}, 22, 0)

VBAGuru

Or change this to:

=IFERROR(VLOOKUP({Production Plan - Completed / Archived Range 1}),22,0) * VLOOKUP({New Production Plan Range 1},25,0)),"")

VBAGuru

Did either of those work for you?