# 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

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.

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.

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.

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

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.`

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?

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

Here's another one...

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