return a value if 2 other criteria match

**di22y** · 01-11-2009, 01:25 PM

Rather than attempt to describe my problem here and risk cofusing people on what I want to achieve I have put a diagram together. I think this is the best way to illustrate my problem.

Diagram is available here
http://uk.geocities.com/di22y@btinte...iondiagram.jpg
There is also a copy of the document available here for any body willing to take a look.
http://uk.geocities.com/di22y@btinte...m/lookhere.xls
Please bare in mind I need this doc to be compatible with the 2003 version of Excel.

Any help would be greatly appreciated.

**stanleydgromjr** · 01-11-2009, 02:15 PM

di22y,

Your JPG is not available: "Sorry, Service Temporarily Unavailable."

And, I do not have a clue in reference to your workbook.

Please explain in detail what you are attempting to do.

Have a great day,
Stan

**Domenic** · 01-11-2009, 02:21 PM

First download and install the free add-in, Morefunc. Then try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX(THREED('Starts Jan:Starts Dec'!$E$5:$E$100),MATCH(1,IF(THREED('Starts Jan:Starts Dec'!$C$5:$C$100)=G4,IF(THREED('Starts Jan:Starts Dec'!$H$5:$H$100)=P4,1)),0))

Hope this helps!

**di22y** · 01-11-2009, 02:44 PM

Originally Posted by Domenic

First download and install the free add-in, Morefunc. Then try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX(THREED('Starts Jan:Starts Dec'!$E$5:$E$100),MATCH(1,IF(THREED('Starts Jan:Starts Dec'!$C$5:$C$100)=G4,IF(THREED('Starts Jan:Starts Dec'!$H$5:$H$100)=P4,1)),0))

Hope this helps!

Thanks for the suggestion but will this work if open the document on other computers without the add-in. If it wont then this is not an option for me.

**Domenic** · 01-11-2009, 03:05 PM

There's no need for other computers to install the add-in. There's an option which let's you embed the add-in within the file itself.

**di22y** · 01-11-2009, 03:36 PM

Originally Posted by Domenic

First download and install the free add-in, Morefunc. Then try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX(THREED('Starts Jan:Starts Dec'!$E$5:$E$100),MATCH(1,IF(THREED('Starts Jan:Starts Dec'!$C$5:$C$100)=G4,IF(THREED('Starts Jan:Starts Dec'!$H$5:$H$100)=P4,1)),0))

Hope this helps!

Just tried the above and Excel is returning with na, any other suggetions that I could try.

**Domenic** · 01-11-2009, 03:58 PM

Did you confirm the formula with CONTROL+SHIFT+ENTER, not just ENTER? If done correctly, Excel will automatically place braces {.....} around the formula.

**di22y** · 01-11-2009, 04:10 PM

Originally Posted by Domenic

Did you confirm the formula with CONTROL+SHIFT+ENTER, not just ENTER? If done correctly, Excel will automatically place braces {.....} around the formula.

Confirmed with Ctrl+Shift+Enter and excel placed the {} around the formula this returns the na value.

Out of curiosity did it work for you. If it did I know Im doing something wrong. But I did copy the formula straight from your revious post. Im now gonna try and type it in to the formula bar just incase this makes any difference.

cant thank you enough.

**Domenic** · 01-11-2009, 04:36 PM

Unfortunately, the add-in is not compatible with my Mac version of Excel so I'm not able to test it. But I re-checked the formula and it should return the desired result. Are you still having problems?