I think this has a simple solution, but can't seem to find it. I want to return a specific number based on what letter is in another cell. For example if A1 is "A", "B", "C", or "D", I want to return 0, 9, 18, and 27 respectively. I know this can be done with a nested IF function or a lookup table, but was thinking there was a simpler way. Using Excel 97. Thanks.
Last edited by Russet; 10-24-2015 at 11:02 AM.
Try
=(MATCH(A1,{"A","B","C","D"},0)-1)*9
This isn't a lookup table per se and I can't say it will work in excel 97 but this works with my version... =LOOKUP(A1,{"A","B","C","D"},{0,9,18,27})
though for anything beyond D (like E or F for example) it will also return 27.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you so much for the replies! The formulas worked perfectly and I can use both of them.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks