Index Match

[DRExcel515]

Ok I have an index(Match formula I'm using.... IFERROR(INDEX('Master Portfolio Sheet'!C$3:C$187,MATCH(1,INDEX(('Economic Macro'!$G$2='Master Portfolio Sheet'!B$3:B$187)*('Economic Macro'!$A18='Master Portfolio Sheet'!A$3:A$187),0),0)),"")

I understand that this is making sure two variables are true before bringing in the stat that I am looking up. Is there a way to alter this formula to basically say if one condition is not true, look at the next stat to see if it is true and so on until it finds a match? There would be three possible columns where I'd want to find a match if that helps.

Any help would be much appreciated

Cheers!

 

[Chrisdontm]

Re: Index Match Help

This may send you off into the right direction, you may need to play with it a little;

=IFERROR(INDEX('Master Portfolio Sheet'!C$3:C$187,MATCH(1,INDEX('Economic Macro'!$G$2='Master Portfolio Sheet'!B$3:B$187,),0)),IFERROR(INDEX('Master Portfolio Sheet'!C$3:C$187,MATCH(1,INDEX('Economic Macro'!$A18='Master Portfolio Sheet'!A$3:A$187,),0)),""))

Then in that last part of the last IFERROR, you would want to do another IFERROR like the ones before it for your third option...

I hope this helps...

 

[DRExcel515]

Re: Index Match Help

That's just about how I fixed it Thanks for the reply!