Help adding 1 more item to this formula

[thewiseguy]

Hi everyone,

Hopefully I can explain this correctly. Here is my current formula:

=IF(ISERROR(INDEX(Sheet3!$D$5:$D$200,MATCH(E5,IF(Sheet3!$C$5:$C$200=C5,Sheet3!$A$5:$A$200),0))),"0",INDEX(Sheet3!$D$5:$D$200,MATCH(E5,IF(Sheet3!$C$5:$C$200=C5,Sheet3!$A$5:$A$200),0)))

I would like to add one more item to match. I need to match column H in my current sheet, to that of column E in sheet 3. Just not sure how to go about it.

Any help is greatly appreciated.


-m

 

[Domenic]

Try...

=IFERROR( 
    INDEX(Sheet3!$D$5:$D$500, 
      MATCH(1, 
         IF(Sheet3!$A$5:$A$500=F5, 
         IF(Sheet3!$B$5:$B$500=G5, 
         IF(Sheet3!$C$5:$C$500=C5, 
         IF(Sheet3!$E$5:$E$500=D5, 1)))),0)),0)

Hope this helps!

 

[Aladin Akyurek]

Aladin,

I put the formula in exactly as you typed, but it is telling me there are too few arguments. Any ideas?

The closing paren for INDEX and the return value for IFERROR are missing... See Domenic's fill in.

 

[thewiseguy]

thanks guys, its working now!


-m