Posted to microsoft.public.excel.misc

Ken

external usenet poster

Posts: 590

Index/Match/Offset/Sum (maybe?)

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OFFSET vs INDEX(MATCH(...))	Dave F[_2_]	Excel Discussion (Misc queries)	1	January 15th 08 03:12 PM
using OFFSET(INDEX(MATCH)))	Dave F[_2_]	Excel Discussion (Misc queries)	3	September 25th 07 06:44 PM
INDEX, MAX, OFFSET, MATCH	Joe Gieder	Excel Worksheet Functions	2	June 15th 07 01:34 PM
index match offset?	denise	Excel Worksheet Functions	10	July 4th 06 04:28 AM
Index, Match, Offset? Not sure which to use	Ms. P.	Excel Worksheet Functions	4	July 29th 05 11:04 PM

All times are GMT +1. The time now is 01:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us