I am working on a spreadsheet with 7 columns. The first six have 7 digit stock numbers in fields from 2 - 65536. The seventh column contains a similiar 7 digit stock number, but only goes from G1-G2800. I want to start at G1, check for the existence of its' contents in columns A:1 - F:65536, if found, place a "not ok" in the adjacent field (H1), then check G2, G3, etc. Is there a way to automate this process using VLookup?? I have five other speadsheets with a similiar quantity of numbers to check after this one is completed!
Thanks for the help!
Tim