Trying to find a formula that will compare a number between 2 columns are
return the 3rd column

Something onlong the lines of
=If(And(NumberCol_A,Number<=Col_A),Col_c,"NotFoun d")

Col_A Col_B Col_C
20100101 20100129 JAN
20100129 20100226 FEB
20100226 20100402 MAR

so if Number='2010304' the result is 'MAR'
--
Thanks & Best Regards