Cell Value Based on Another Cells Calculation

[Diane]

AHA!!!! It works! Using this formula:


=IF(ISNUMBER(MATCH($D$16,$A$18:$A$42,0)),"LQR",IF(ISNUMBER(MATCH($F$16,$A$18:$A$42,0)),"SOP","N/A"))


And changing the date to include DAYS I get the appropriate value!!!! Um...but I don't want to match the DAY of the evnet, jsut the MONTH of the event.

 

[Diane]

DANG! Luke, that's it!!! I'm gonna play a bit more fudging some dates for testing.

 

[Diane]

well, I've done my testing and it's perfect! Thanks so much!