I have a dropdown list with High, Med and Low
I am trying to have a value High 1, Med 3 and low 5.
My final out come I want to add 1, 3, or 5 days to my due date cell.
Thanks
Brad
I have a dropdown list with High, Med and Low
I am trying to have a value High 1, Med 3 and low 5.
My final out come I want to add 1, 3, or 5 days to my due date cell.
Thanks
Brad
Try this:
=LOOKUP(A1,{"High","Low","Med"},{1,5,3})
where A1 is the cell with the list.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
By the way, you still haven't acknowledged the help you were given here back in August: https://www.excelforum.com/excel-gen...ml#post5169762
You are correct, my apologies... But so far your answer has helped so much.
I try to figure Excel out on my own but.....
Thank you so much, now I can go on w/ my next excel issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks