Alright then, put this formula into M1 on the CLIENT... sheet just as you did
the previous one. This time, the "move cursor to lower left corner of M1 and
double-click" should work to fill the formula down the sheet.
Yes, this is just one huge formula ---
=IF(G1=INDEX('IFC PRICE 2008'!G$1:G$7775,MATCH(A1,'IFC PRICE
2008'!A$1:A$7775,0),0),IF(H1=INDEX('IFC PRICE 2008'!H$1:H$7775,MATCH(A1,'IFC
PRICE 2008'!A$1:A$7775,0),0),IF(ISNA(VLOOKUP(A1,'IFC PRICE
2008'!A$1:M$7775,13,FALSE)),"No UPC Match",VLOOKUP(A1,'IFC PRICE
2008'!A$1:M$7775,13,FALSE)),"Size (W) Mismatch"),"Size (L) Mismatch")
What it does is first make sure that the length values in column G of both
sheets match for the first MATCH on the current UPC code, and if that
matches, check for match of the width in column H, again for the current UPC
Code. If either of those does not match you'll get an indication of that.
If both Width and Length don't match, then you'll get the indicator that the
Length didn't match. It continues on to either return the matching price (if
length/width matched) or tell you that it couldn't find the current UPC code
over on the ...2008 sheet.
Now, for any 'error' indicators that you replace with a manually entered
price, you have to remember that the formula will get erased on the CLIENT...
sheet, column M in that/those cell(s). A cell can hold a formula or a value,
not both. We start with formulas, you may end up changing some to values.