choose formula help

[ganeshpoojary05]

Hi all,

I need a help in a formula. I'm pasting the example below:

Range(A1) can contain "A", "B", "C", "D", "E", or "F"

and if A1 contains A then it should return a value 100, if B then 200, if C then 300, if D then 400, if E then 500, if F then 600. I know this can be possible by If condition, but i need some more easier and short formula. Please help. Thanks in advance for your assistance.

 

[Marcelo Branco]

Or maybe

=LOOKUP(A1,{"A";"B";"C";"D";"E";"F";"G"},{100;200;300;400;500;600;"Not Found"})

M.

 

[taurean]

That really is a better formula!
Thanks, its learning curve!!

 

[ganeshpoojary05]

Thanks all for your wonderful support.

 

[Marcelo Branco]

That really is a better formula!
Thanks, its learning curve!!

You are welcome

M.