=IF($N$29="","",+VLOOKUP($N$29,'P:\Production\Our inventory Shop Orders\[sku_numbers.xlsx] items'!$A$2:$W$3000,16,FALSE))

That is the command I have. Sometimes excel looks up the information correctly but most of the time it spits out NA or all 0's. I can hit F2 TAB and then select the file and the information will come in correctly and hitting Ctrl Alt F9 will fill the rest in. That's my way around the error, I need to know how to not get the error in the first place.

Thanks