look-up issue with multiple criteria

Hello All

I have faced issue with lookup ...

attached file shows in sheet POs:
1. PO numbers (column "A")
2. Material (column "B")
3. Vendor (column "C")
4. document type (column "D")
5. invoice date (column "E")

in sheet MAIN I'm trying to lookup the latest invoice date (column "E") for listed parts based on criteria as following:
1. part number matches document type - "NB"
2. part number matche PO number - 47xxx
3. lookup excludes certain suppliers (listed A4:A15 listed in sheet MAIN)

in sheet Main in column "B" i applied formula:
=MAX(IF(($A18=POs!$B$2:$B$2160)*(POs!$D$2:$D$2160=POs!$D$2)*(LEFT(POs!$A$2:$A$2160, 3)="470")*(ISERROR(MATCH(POs!$C$2:$C$2160, MAIN!$A$1:$A$15, 0))), POs!E2:$E$2106, ""))


however it seems formula is not working correctly as for example part in line 39 (MAIN sheet) - 161A4305-2:81205 returns #N/A while part belongs to 47xxx and "NB" criteria.
there are more #N/A that should have value after lookup

Can you please advise where is the problem and what shall be corrected?
maybe some other formula?

Thank you

your PO date range is incorrect - should be absolute, and reference same rows, i.e: POs!$E$2:$E$2160

the date range is still wrong, you are referencing row 2106 rather than 2160 - as highlighted in prior post.

Hi
apparently I'm blind
thanks