Index/Match/Offset/Sum (maybe?)

K

Ken

Excel2003 ...

Merged Cells A15:C15 contain PN
Range A26:C65 contains PNs with Merged Cells A26:C26 containing 1st PN
Cells A29, B29, C29 contain numeric values.

I would like 2 Formulas:

In Cell D15 ... Match PN in A15 with PN in A26 ... return SUM of values A29,
B29
In Cell E15 ... Match PN in A15 with PN in A26 ... return value in C29

Thanks ... Kha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset/Index/Match ... or something? 3
SUMIF? 9
Index/Match Lookup with a merged col 2
Index and Match 5
Offset??? 2
Index/Match (maybe?) 9
row lookup help! 2
Event Macro - Hyperlink selected 0

Top