match and display
Assuming you are dealing with numbers, I believe this will work (place into
Sheet2!B2):
=SUMPRODUCT(--(Sheet2!$B$1=Sheet1!$B$2:$B$10),--(Sheet2!A2=Sheet1!$A$2:$A$10),(Sheet1!$B$2:$B$10))
Formula looks up A2 in Sheet1, and if corresponding value in Sheet1 column B
= Sheet2!B2, returns value from Sheet1 column B.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"gootroots" wrote:
example;
sheet1;A2:A10 and sheet2;A2:A10 contain the same unique values
sheet1;B2:B10 contains no unique values
sheet2:B1 contains a value
I need a formula that will return a match to correspond with sheet2;B1 and
sheet1;B2:B10 and if found return it in sheet2;B2:B10
Bearing in mind that sheet1;A2:A10 and sheet2;A2:A10 must also match
Thank you if you can be of help.
|