Forum Discussion

Jeremy Wilkerson's avatar
Jeremy Wilkerson
Copper Contributor
Apr 20, 2018
Solved

Formula help

I need help creating the formula for cell F3. Stating that if cell D3 is as follows: 1-5=0 6-8=3 9-11=4 12-14=6 15-17=8 18-19=10 20-21=12 22+=15 I'm sure its a simple formula but I have no i...
Excel Online
Formulas & Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 20, 2018

Hi Jeremy,

 

You can use this formula in cell F3:

=LOOKUP(E3,A2:C9)

 

Please find the attached file.

 

Regards

Sameh Rafik's avatar
Sameh Rafik
Copper Contributor
Oct 25, 2018

Hi Haytham,

 

I actually tried the same formula for the attached sheet, but it does not give the correct output most of the time, I wanted to categorize the C column to different seasons depending on the range of dates, wondering if you can help me :)

Thanks in advance,

Sameh

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 25, 2018

    Hi Sameh Rafik,

     

    That's because the table of seasons in the Arrays sheet isn't sorted!

    It MUST be sorted to get the correct result from the LOOKUP function.

     

    Anyway, I've sorted it for you.

    Please find the attached file.

     

    Regards,

    Haytham

    • Sameh Rafik's avatar
      Sameh Rafik
      Copper Contributor
      Oct 25, 2018
      Thanks a lot Haytham, that has been very helpful

Resources