Find the MONTH in a range when we're provided the entire date

**daddylonglegs** · 01-23-2012, 09:40 PM

adaws has the right idea. You can apply TEXT function to the named range IO_Months to pull out the month as text. Try this version

=IFERROR(LOOKUP(2,1/(OrderIDs=K28)/(TEXT(IO_Months,"mmmm")=E30),ROW(IO_Months)),0)

**Habanero Time** · 01-23-2012, 09:50 PM

Originally Posted by daddylonglegs

adaws has the right idea. You can apply TEXT function to the named range IO_Months to pull out the month as text. Try this version

=IFERROR(LOOKUP(2,1/(OrderIDs=K28)/(TEXT(IO_Months,"mmmm")=E30),ROW(IO_Months)),0)

That did it!

THANKS!