Good Morning,
I have attached my spreadsheet that I am working on so you can see what I am trying to accomplish.
In the possible violations, I would like to see more than one violation show up in the same cell.
EG: >13 Driving >14 On-Duty
At the moment my formula will only determine one. I would like them both to enter if the criteria is met.
Does this make sense?
Hello
Try the following formula in B8 across:
Formula:
Please Login or Register to view this content.
Hope this helps.
DBY
I would set up a small table for this, and have all the "answers" in there, with their numbers. You could then do multiple lookup's into that table and return all the answers
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This worked perfectly and was exactly what I was looking for. Thank you DBY so much for your help.
Last edited by DonnaLynn; 03-30-2016 at 02:29 PM.
Glad to have helped. Thank you for the Rep mark.Ford's suggestion is a good one if you have many variables to return or if you need to edit the values in any way.
Thank you so much FDibbins.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks