Hi there, really sorry if this is a basic newbie question which I am sure it is! I have surfed through the threads so far and done a bit of Googling but am still lost. I am getting stuck between, VLOOKUPs, If - then- and also the Substitute option but really have no idea
On a sheet I have several cells containing a drop down box with the options of E,H,G,L
I would then like to use a formula which will take that value and convert it to a number in another cell in the next column or so over so I might create a graph from the numerical values.
EG: a selection of E in the drop down would put a 10 in another cell, a selection of H in the drop down would put an 8 in another cell, a selection of G in the drop down would put a 6 in another cell and a selection of L in the drop down would put a 3 in another cell.
Sorry to break it down so much for all you experts but I am trying to hit a deadline and am starting to get desperate as I can't nut this out to complete my work! Any help would be greatly appreciated!
Cam
Your explanation is very vague. You said "... On a sheet I have several cells ..."
Then you said:
"...a selection of E in the drop down would put a 10 in another cell, a selection of H in the drop down would put an 8 in another cell..."
Hum?? "... another cell..." Does that mean that the "other cell" depends on the value selected from the dropdown?? Hopefully, you meant the same cell but different values in that cell based on the dropdown choice.
Now, working with the vagueness, say your dropdown is in A1 and you want the value in "... another cell ..."to reflect A1. Then in
... that other cell ...
put something like:
=CHOOSE(MATCH(A1,{"E","H","G","L"},0),10,8,6,4)
P.S. sample workbooks help so much ......
Last edited by protonLeah; 10-25-2011 at 10:43 PM.
---
Ben Van Johnson
See if this workbook is on the lines you are thinking.
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Hi Cam and welcome to the forum.
You could also create a VLookup Table with the letters and the numbers next to them. Use this table to return the numbers for the letters.
See the attached for the example.
One test is worth a thousand opinions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks