Dominique Feteau

Posts: n/a

Index & Match

I got a hand from someone on here (frank) with this function:

=INDEX(A2:O34,MATCH(1,(C37=A2:A34)*(D37=B2:B34),0) ,MATCH(C38,Months,0)+2)

I do have a questioni about it tho. How could I tweak it so that it if
there are 2 or more columns with the same value that it will add them
together?

thanks
niq

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Match, Index, Vlookup, Large....Help Please	[email protected]	Excel Worksheet Functions	3	December 15th 04 01:38 PM
Match, Index, Vlookup, Large....Help Please	[email protected]	Excel Worksheet Functions	0	December 14th 04 11:16 PM
Match & Index	Phyllis B.	Excel Worksheet Functions	2	November 27th 04 03:26 PM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM
Vlookup, Index & Match	Phyllis	Excel Worksheet Functions	1	November 8th 04 06:11 PM

All times are GMT +1. The time now is 01:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us