Lookup Formula

[rglasunow]

I'm trying to create a lookup formula on a spreadsheet. I was able t
get it to lookup on item but I have 5 additional items that I woul
like to do something like an IF THEN formula.

This is what I currently have:

=IF(I3="Summer","4/8",0)

But what I would like to do is have a Fall, Winter and Spring option i
there as well and if one of those is selected then another date woul
be inserted.

Thanks in advance

 

[Jason Morin]

One way:

=VLOOKUP(I3,
{"Summer","4/8";"Fall","F";"Winter","W";"Spring","SP"},2,0)

where "F" = fall date, "W" = winter date, "SP" = spring
date. Note that this formula is returning text strings,
not actual dates with which you can perform calculations.

HTH
Jason
Atlanta, GA

 

[Bob Phillips]

This should get you started

=LOOKUP(I3,{"Winter","Spring","Summer","Fall"},{"1/8","2/8","4/8","6/8"})

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[rglasunow]

Thanks to the both of you for the quick response!! Both ways worke
great

 

[rglasunow]

Looking at the formula now I realized that if the cell is currentl
blank I am getting a #VALUE in the cell. Is there anything I can do t
get rid of that?

THanks

 

[PeterAtherton]

Using Bob's formula

=IF(I3="","",LOOKUP(I3,{"Winter","Spring","Summer","Fall"},
{"1/8","2/8","4/8","6/8"}))

Regards
Peter

 

[Guest]

----- rglasunow > wrote: ----

I'm trying to create a lookup formula on a spreadsheet. I was able t
get it to lookup on item but I have 5 additional items that I woul
like to do something like an IF THEN formula

This is what I currently have

=IF(I3="Summer","4/8",0

But what I would like to do is have a Fall, Winter and Spring option i
there as well and if one of those is selected then another date woul
be inserted

Thanks in advance


--


Try this

=IF(I3="spring","3/20",IF(I3="summer","6/21",IF(I3="autumn","9/22",IF(I3="winter","12/21","")))