INDEX MATCH, 3 Inputs, Slighly odd range size

**Sordini** · 06-01-2012, 09:44 AM

Howdy folks, this one has had me stuck for a about an hour :-(
The Googling just wont help me. Emphasis on me :-)
Any help appreciated

**Fotis1991** · 06-01-2012, 09:51 AM

Hi

As i see your data, this must works for you.

=SUMPRODUCT((A7:A18=B1)*(C7:C18=B3)*(E7:E18))

Does it?

**Sordini** · 06-01-2012, 09:56 AM

Thanks for the reply
I am afriad that does not work, as "Qty 2" is a variable, or moving column.
In your formula the answer range is considered to be static, however sadly that is not the case

**Fotis1991** · 06-01-2012, 10:04 AM

You mean could be or in column B or in Column E, or somewhere else?

**Sordini** · 06-01-2012, 10:05 AM

Yes,
B or D or E (only)
Not C

**Fotis1991** · 06-01-2012, 11:08 AM

Hi

Sorry for the dalay. A long......phone call..

So this must works for you. Does it?

Please Login or Register  to view this content.

**Sordini** · 06-04-2012, 03:20 AM

That was Awesome.
This thinking-way I can apply to many things going forward.
Thank you so much Fotis1991!

**Fotis1991** · 06-04-2012, 03:59 AM

You are welcome!

Thanks for the reb*

INDEX MATCH, 3 Inputs, Slighly odd range size

LinkBack

Thread Tools

Rate This Thread

Display

INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Re: INDEX MATCH, 3 Inputs, Slighly odd range size

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions