How can I write a formula thats says if E6 says "1" then display A, if E6 says "2" then display B, if E6 says "3" then display C. Otherwise blank.?
How can I write a formula thats says if E6 says "1" then display A, if E6 says "2" then display B, if E6 says "3" then display C. Otherwise blank.?
=iferror(lookup(e6,{1,2,3},{"a","b","c"}),"")
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Or..
Formula:Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Or..
Formula:Please Login or Register to view this content.
or..
Formula:Please Login or Register to view this content.
Thank you for your reply. I used 123 ABC in attempt to simplify things assuming I could edit it to my needs, but I must be doing something wrong. Basically I would like to combine all three of these codes into one cell:
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
I found my answer here:
http://www.excelforum.com/excel-gene...ther-text.html
Thanks for you time time guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks