First off sorry for the lengthy post. I hope I was clear, if not please let
me know. I was wondering, can INDEX be used twice in a row and is tis even
the right direction? This is the current formula I use:
array entered
=IF(H3="Yes",'MSP
Listing'!$C$2,IF(ISNA(MATCH($K3&S3&$W3,PN&UnitCost &Supplier,0)),"",INDEX(QuoteRecvd,MATCH($K3&$S3&$W 3,PN&UnitCost&Supplier,0))))

Sample data I use
worksheet1 (Results)
H K S W X
3 1234 $5.25 xyz co formula here

worksheet2 (Data)
I AB AM AS BG
P/N UnitCost Supplier QuoteRecvd Updated
3 1234 $5.25 xyz co Yes
4 2345 $2.68 abc co 10/21/04
5 1234 $5.25 xyz co 01/05/05
6 1256 $8.25 def co 01/24/05

I need to lookup the following:
MATCH K&S&W (pn, unitcost & supplier) with worksheet2 while INDEXing
Quoterecvd, hence the above formula which retrieves the date. Now I need to
add one more criteria within this formula that will look in the Updated
column and if it says YES ignore it and proceed to the next MATCH. Can this
be done?

Thanks in advance for your help.
Joe