I have a spreadsheet that i am distributing that will be used to correct errors in customer info. I have a 6 characer alpha customer ID that I am giving my accounting office the option of changing BUT i want to put a flag up if that ID already exists in that column. example
old id new id note
------------------------
abcdef dfghij *ID Exists* (finds the id on the 5th line)
bcdefg xvfghj
cedfgh asdfer
edfghi poilj1
dfghij abcdef *ID Exists* (finds the id on the 1st line)
this way they can choose another ID.
i have tried using lookup, and hlookup but im aftraid im just not wrapping my brain around this problem.
any help would be appreciated.
thanks in advance!
Bookmarks