Hello,
I am trying to create a simple link between numbers and text in excel. I have 3 states: 1 = worse case 2 = base case 3= best Case.
I want to create a formula that allows me to link these. For example, if I type in "Worse Case" in a cell, the number 1 should pop up on another cell. If I type in "Base Case", then the number 2 would pop up in another cell.
How can I do this?
Thanks for the help!
Several ways
VLOOKUP
Put the values in a separate table, Let's say G1:H3 with text in G and number in H
Let's say you put "Worst case" in A2, in B2
=VLOOKUP(A2, $G$1:$H$3,2, FALSE)
with LOOKUP
=LOOKUP(A2, {"base case", "best case", "worst case"}, {2, 3, 1})
Edit: Note: The "cases" need to be in alphabetical order for LOOKUP
Last edited by ChemistB; 03-27-2013 at 01:21 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
An if statement would accomplish this:
Formula:
Please Login or Register to view this content.
Please click the * icon below if I have helped.
An if statement would accomplish this:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks