VLookup Formula Error

[i.beard]

I have a file with multiple worksheets and I need to do vlookup of UPCs from 1 worksheet called 0723 and if it is null value then vlookup from another worksheet called productmaster. The formula I came up with is

=IFERROR(VLOOKUP(UPCLookup!A2,'0723'!$B$2:$Y$63014,23,FALSE),IFERROR(VLOOKUP(UPCLookup!ProductMaster !B2:S149824,18,false),””))

This returns an unspecified error and higlights the B2 after productmaster!
What is wrong with my formula?

Please help I am pulling my hair out.

 

[texasalynn]

Welcome to MrExcel Board...

in the second one you don't have a lookup value only the table array

 

[i.beard]

Corrected to the following

=IFERROR(VLOOKUP(UPCLookup!A2,'0723'!$B$2:$Y$63014,23,FALSE),IFERROR(VLOOKUP(UPCLookup!A2,’ProductMaster’!B2:S149824,18,FALSE),””))

Now it opens an update values dialog box and wants me to select a file to update from...?

 

[texasalynn]

are the sheets/file names correct in the vlookups?

 

[i.beard]

Yes I have double checked that.

 

[texasalynn]

I think you had ticks that didn't belong

=IFERROR(VLOOKUP(UPCLookup!A2,'0723'!$B$2:$Y$63014,23,FALSE),IFERROR(VLOOKUP(UPCLookup!A2,ProductMaster!B2:S149824,18,FALSE),""))

 

[i.beard]

Thank you