Lookup 2 values - One Alphnumeric and other is Date.

I have 2 sets of data in same sheet.

Table 1 and Table 2.

Table 1 Contains Code, Date
Table 2 Contain Code, Start_Date, End_Date, Value

Need to fetch Value from Table 2 if Code = Code and Date >= Start_Date and Date<= End_Date

Excel File attached.

If someone can give me the formula for this I would highly appreciate.

Thanks in Advance.

Vetaal.

Paste this formula in H2 then double click the fill handle:

Please Login or Register  to view this content.

Let me know if you have any questions.

After pasting this array formula* into H2, press the F2 key, then press Ctrl, Shift and Enter simultaneously, otherwise it will yield incorrect results:

Please Login or Register  to view this content.

Let me know if you have any questions.

You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.