Excel Formula needed 1

[robertbarrett]

This may just be a complicated IF THEN statement, please help.

I already have a drop down list in place. How can I have whatever value in the drop down list populate a value in another cell?

For example:
"Left Early" I want to populate another cell with 0.50
"Called Off" - 1
"No Call No show" - 2
"Suspension - Violation" - 0
"Excused" - 0

Please advise.

Thank you

 

[SkipVought]

Hi,

I'd use a lookup table like...
[pre]
YourText YourValue
Left Early 0.5
Called Off 1
No Call No show 2
Suspension - Violation 0
Excused 0
[/pre]

[tt]
=INDEX(tLUTable[YourValue],MATCH(E3,tLUTable[YourText],0),1)
[/tt]
...where the text you are looking up is in E3.

Also a Structured Table named tLUTable


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[robertbarrett]

I don't think this is quite what I am looking for.

Column E contains the drop down lists, the options are listed in my OP. I want column G to automatically populate based on the value that is selected from the drop down list

 

[SkipVought]

I'd put the formula in column G referencing the value incolumn E.

So please explain why you think my solution will not work.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

see my wkbk...

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[robertbarrett]

I found an error on my side. This is exactly what I need.

Thank you

 

[SkipVought]

Grrrrreat!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]