I have two fields full of product reference numbers that I want to compare for matches.
The first is called Reference . This is a long list of stuff we make, some of which are out of date and out of stock.
The second is called OldReference , which contains just the old items with remaining inventory.
I want to search the two fields for instances where the reference numbers match, and then mark them somehow. I assume in a third field that returns 1 or 0, true or false, yes or no…
Anybody know how to do this using a formula, lookup field, or some combination?
Thanks in advance to anyone with a good idea. :grinning_face_with_big_eyes:
-Frank