My source file contains the exact city / lot number which coressponds to an exact device number.
I want to take my existing spreadsheet and have all city/lot numbers sync with that of my source file.
So spreadsheet A; ROW 01 would now contain the same device number as Spreadsheet B; ROW 01 and so forth.
If possible I would like to have all fields within this column print the word null if there is no source data for that city /lot
from Worksheet B.
Is this done with a vlookup? I have been trying but to no avail
Yellow cell on worksheet A is what I am trying to pull over from the source worksheet