vba xlookup with #n/a

[mattless1]

Hi i'm looking for some help if possible?

i have a workbook where column A has a list of barcodes this amount can change (workbook1), then i have another workbook (workbook2) which has three columns with barcodes columns C, D & F in it, These relate to the barcodes in workbook1.

is it possible to have a vba code to search the first column C in workbook2 and and return what barcodes it finds then checks the #N/A's and look in the next column D and E so on until its looked through all the #N/A's

thanks in advance.
Matt

 

[S Oberlander]

you can use the IFNA function
why can you just put all barcodes in one column?

 

[mattless1]

I can't pull them in from one column as the database products could have up to three barcodes and they export as barcode1 barcode2 and barcode3. in separate columns
i'll have a look in into IFNA

many thanks,

 

[S Oberlander]

you can do it nested, something like: =IFNA(vlookup(***),IFNA,(vlookup(***),vlookup(***)))