Please could someone explain the lookup for me, or even just tell me what to write! I've looked at the help files, the forum here and the add in on excel but I still get error messages.
In column A on the first tab (called parts) I have a list of part numbers.
In column A on the second tab (called inventory) I have a list of part numbers
In column S on the second tab I have the current inventory which I want to use the part number to find and bring into the first tab and put in column J