If date is not less than list of dates

[SergSlim]

Hello.

I need to add one more if clause to my formula in place of "Installed":
=IF(ISNA(VLOOKUP(C3,Install!H:H,1,FALSE)),"Not Installed","Installed")

What this formula does:
If serial number of particular equipment in C3 is found in column H of Install sheet, than it is Installed, otherwise, it is not.

Everything is fine, unless in column H there is more than 1 such serial. I need it to type "Installed" only in case if it is found in column H of Install sheet, AND date in A3 cell is not less than date in cell Bx of Install sheet for particular serial number.

Example:
Excel takes serial from C3, say 12345678. It goes to Install sheet and compares it with serials in column H.
There are 2 or more such serials in column H, say in H5, H9, and H20.
Now it takes date from A3, say 15.02.2013. It goes to Install sheet and compares it with dates in cells B5, B9, and B20. And only if A3 is >= than any of dates in B5, B9 or B20, than type "Installed", otherwise "Not Installed", which means if it was installed prior to date in A3 - consider it as not installed.

[Pepe Le Mokko]

Please post a sample sheet

[SergSlim]

I've attached an example. It's a bit more complicated in terms of formulas.

Arrivals tab:
D37 should be Not Installed, because there is no modem with 001AC310E3F2 serial installed on or after 01.03.2013 on Installed tab.

Test.xlsx