If statement HELP!

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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!
 
With your data in A1:B8 try the below formula

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

If this post helps click Yes
 
Michelle,

Try this

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

Mike
 
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!!!
 
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),"")
 
Try
=CHOOSE(CODE(UPPER(F3))-64,36,30,24,18,12,12,6,6)

If this post helps click Yes
 
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
 
Back
Top