Formula needed

[snash]

In sheet1, I have a list of barcodes.
In sheet 2 I have 2 columns of barcodes and and a column of product codes.

In sheet one, against the barcode, I'm trying to get the product code but as mentioned I've 2 columns of barcodes. how do I incorporate the 2 columns of data? Is it a lookup or ismatch or something?

Thanks in advance

 

[t0azt]

you can do an iferror with 2 vlookups. If the barcode is not in the first column it will look in the second. So, assuming in sheet2 you have barcodes in columns A and B and the product code in column C and the barcode you're looking up is in A1 in sheet1 it will look something like this:

=IFERROR(VLOOKUP(A1,Sheet2!$A$1:$C$34,3,0),VLOOKUP(A1,Sheet2!$B$1:$C$34,2,0))

Adjust your ranges accordingly.

 

[snash]

That's perfect - thank you!