=LOOKUP(A1,{"Alaska","Maine","New York",""},{13,48,25,""})

If more cases, use a VLOOKUP table.


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 06:55:01 -0700, shallowz
wrote:

Thank you very much that did work
how do i make it so if i have two or more to add like
Maine will equal the number 48 and
Alaska will equal the number 13

thanks so far for your help

"Stefi" wrote:

=IF(A1="New York",25,"")
Regards,
Stefi

„shallowz” ezt írta:

i am a noob when it comes to excel formula's

this is what i want i hope it can be done

if in cell A1 i have the word New York i would like to have cell A7 show a
number like a 25

Cell A1
New York

As soon is that is typed in

Cell A7
25
Pops up

what is the formula i put in A7 so that can happen please