Ok, so i have a list of fleet numbers below
12848
518968
15684
121684
I need a forumla to go next to these fleet numbers that does the following:
Checks if that fleet number is listed in a list on another tab, and return Y or N.
BUT then i also want it to look on a 3rd tab, and see if the fleet number is listed in that tab.. and if it is, say "VOR" (vehicle off road).
Can anybody help?
Do i need a SUMPRODUCT formula?
15168HELP.png
Bookmarks