Could be a simple fix?

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello, I'm having trouble getting the two columns to find the perfect match, then give me a return value. I need Col A = Col X and Col B = Col Y (if they both match, then return value from Col Z to Col C) If not, then "0" or "n/a". Example below:

Sheet #1 Sheet #2

Col A Col B Col C Col X Col Y Col Z
Date Product code avg cost Date Product code avg cost

5/1/09 ABC (to be filled) 5/1/09 ABC $55.27


Thanks for your help,
Pam

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
=if((Col A = Col X)*(Col B = Col Y)=1,Col Z,0)