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
Please post a sample file not an image.
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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.
Last edited by vkz7hxy; 11-11-2015 at 09:42 AM.
End result: Column 'H' should be full of Y's and N's, and a few VOR's
Last edited by vkz7hxy; 11-11-2015 at 09:43 AM.
Denmark Utilisation.xlsx
Thanks!
Try this formula
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks worked perfectly!
Any way of you explaining what you've done so i can do it in future?
Here's another one...
=IF(COUNTIF('DIR DIAD'!E:E,D2),"Y",IF(COUNTIF(VOR!A:A,D2),"VOR","N"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks