Formula to Lookup value based on date within a date range

Hello,

Title is probably confusing, but I'm going to try to describe my situation as best as I can.
I need a formula for searching a date if it's within a date range and get data on another column based on the results.

For instance,
the date is 4/29/13 and is located in the tab labeled "533_Rpt" in cell J1
I need it to search for that date within a range of dates located in the tab labeled "Switch". Column W has teh start date of month (1/1, 2/1, 3/1, etc.) and column X has the end date of the month (1/31, 2/28, 3/31, etc). Column Y has the value that I need the formula to bring over tot he "533_Rpt" tab in cell K1.

What would be the best way to achieve my results?
This is the formula I cuurently have that does not work:
{=IF(('533_Rpt'!$J$1>=Switch!$W$2:$W$253)*('533_Rpt'!$J$1<=Switch!$X$2:$X$253),MATCH(ROW(Switch!$Y$2:$Y$253),ROW(Switch!$Y$2:$Y$253)))}


Thank you,
Miriam

Try this assuming the dates in column W are sorted in Ascending order.

=LOOKUP('533_Rpt'!$J$1,Switch!$W$2:$Y$253)

That is AWESOME!!!
It worked perfectly. Clearly I could not think of something as simple as that formula.


Thank you!!!

You're welcome.