# Formula:Checking if (A) is in one list, returning Y then checking for (A) in another list

1. ## Formula:Checking if (A) is in one list, returning Y then checking for (A) in another list

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  Register To Reply

2. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

Please post a sample file not an image.  Register To Reply

3. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

Many members are unable to see images in the *.png format.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.  Register To Reply

4. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

File attached
Many thanks!

For clarity on file i attached above... the formula in question is column H on the Summary tab.

Column H should have "Y" if the fleet number is in tab 'DIR DIAD', "N" if not but then look if it's in the 'VOR' tab and return "VOR" if found.  Register To Reply

5. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

End result: Column 'H' should be full of Y's and N's, and a few VOR's  Register To Reply

6. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l  Register To Reply

7. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

Try this formula

Formula:  `Please Login or Register  to view this content.`  Register To Reply

8. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

Thanks worked perfectly!

Any way of you explaining what you've done so i can do it in future?  Register To Reply

9. ## Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

Here's another one...  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 