Returning a value based a list

[Honeycutt]

I have 4 categories Group, Mental, FC, FM. If I select Group or Mental I need in the first cell to put "90" and if it is FC or FM I need it to enter 180.

I will then have that hidden as my calculation for the number of days until the next meeting. For example my first meeting was 01/01/2019 and if falls under FM so it will calculate 180 days from that date

I am trying to teach myself but I have hit a roadblock

 

[LouisT]

Use an "OR" formula nested in a Vlookup or a nested IF statement. For example: =IF(OR(E3=C3,E3=C4),90,0)

E3 would be where the Group Categories are entered
C3 & C4 are just where the list of 4 categories are listed but you could just as simply type the words in the formula.

Hope this helps
LouisT

I have 4 categories Group, Mental, FC, FM. If I select Group or Mental I need in the first cell to put "90" and if it is FC or FM I need it to enter 180.

I will then have that hidden as my calculation for the number of days until the next meeting. For example my first meeting was 01/01/2019 and if falls under FM so it will calculate 180 days from that date

I am trying to teach myself but I have hit a roadblock