Using INDEX & AND

J

Joe Gieder

I need to retrieve the latest date from my worksheet (QuoteRecvd) by using a
set of different criteria. I have this array formula
=IF(H3="Yes",'MSP
Listing'!$C$2,IF(ISNA(MATCH($K3&S3&$W3,PN&UnitCost&Supplier,0)),"",INDEX(QuoteRecvd,MATCH($K3&S3&$W3,PN&UnitCost&Supplier,)))))
which works fine if I don't care about the latest date, but now I do. The
Criteria I use is: item (K3) to PN, cost (S3) to Unitcost and supplier (W3)
to Supplier. I tried the same formula by replacing INDEX(QuoteRecvd, with
INDEX(AND(QuoteRecvd,Updated<>"YES") but received a #VALUE! error. Is there a
way to also filter on the Updated field (BG3:BG1500)?
If more clarrification is need please ask, I tried to explain the best I
could.
Thanks for you help
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top