If statement HELP!

[Michelle]

I am trying to create a formula that will do this:

Look at a letter in cell f3--

If it's Then it should write
-----------------------------------
A 36
b 30
C 24
D 18
E 12
F 12
G 6
h 6

Thanks so much!

 

[Jacob Skaria]

With your data in A1:B8 try the below formula

=VLOOKUP(F3,A1:B8,2,0)

If this post helps click Yes

 

[Mike H]

Michelle,

Try this

=LOOKUP(F3,{"a","b","c","d","e","f","g","h"},{36,30,24,18,12,12,6,6})

Mike

 

[Michelle]

That isn't doing it... I want the formula to be in cell r3, based on what the
letter value of F3 is. Does that make sense?

Thanks!!!

 

[T. Valko]

Assume you have this data in a 2 column list in the range A1:B8:

A 36
b 30
C 24
D 18
E 12
F 12
G 6
h 6

Then:

=IF(COUNTIF(A1:A8,F3),LOOKUP(F3,A1:B8),"")

 

[Jacob Skaria]

Try
=CHOOSE(CODE(UPPER(F3))-64,36,30,24,18,12,12,6,6)

If this post helps click Yes

 

[Michelle]

That did it, Mike..thank you so much!!

Michelle,

Try this

=LOOKUP(F3,{"a","b","c","d","e","f","g","h"},{36,30,24,18,12,12,6,6})

Mike

 

[Gord Dibben]

If those are you only choices.

=LOOKUP(F3,{"A","B","C","D","E","F","G","H"},{36,30,24,18,12,12,6,6})


Gord Dibben MS Excel MVP