Could be a simple fix?

Closed
Pam - May 13, 2009 at 07:59 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - May 14, 2009 at 02:27 AM
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 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
May 14, 2009 at 02:27 AM
=if((Col A = Col X)*(Col B = Col Y)=1,Col Z,0)
0