Hi there,
I have been look through other threads and watching youtube videos but nothing is giving me the answer.
I have created a validation list with the following options
EPR
T-Quest
Manual
However i want the selection of one of these to represent a numerical figure for a later equation .
For example if you select EPR it will mean 20min, T-Quest 40min and Manual 60mins.
Would really appreciate any help,
Thanks
You could INDEX the durations and MATCH the related codes to give the result you are looking for.
In the attached sample I have set up the codes and their matching durations in cells A2:B4 then entered this formula into cell F2: =INDEX($B$2:$B$4,MATCH(E2,$A$2:$A$4,0)). By changing the code in cell E2 you can see the effect in cell F2.
Good luck with it.
Last edited by tuph; 09-23-2016 at 12:21 AM. Reason: Attachment
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Thank you so much!
That has worked perfectly
You can use in F2:
=VLOOKUP(E2,$A$2:$B$4,2,0)
If there are only 3 options you could use a nested IF formula.
=IF(A1="EPR",20,IF(A1="T-Quest",40,IF(A1="Manual",60,"")))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks