If statement HELP!

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!
 
J

Jacob Skaria

With your data in A1:B8 try the below formula

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

If this post helps click Yes
 
M

Mike H

Michelle,

Try this

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

Mike
 
M

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

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),"")
 
J

Jacob Skaria

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

If this post helps click Yes
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top