IF OR Vlookup (Vlookup against multiple sheets)

Hi,

Yes, this is a job for VLOOKUP.

Give this a try:

=IFERROR(VLOOKUP(A2,'Sheet 1A'!A:B,2,FALSE),IFERROR(VLOOKUP(Master!A2,'Sheet 1B'!A:B,2,FALSE),""))

Hope this is helpful.

Cheers