I have created a VLOOKUP for searching for the product name in the product workbook when the product ID has been entered:
=VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)
However although this should work i dont know why it keeps coming back with #NA
????
=VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)
However although this should work i dont know why it keeps coming back with #NA
????