Forum Discussion
Index Match Return with IF function.
can somebody help me with this, I've been struggling to mix IF, INDEX and MATCH functions.
My target usage of the formula is to get the value of another index if the first condition of the index is not met (empty).
The Formula goes like this.
=IF(INDEX('DATABASE '!$D$2:$D$1210,MATCH(1,($A$1='DATABASE '!$A$2:$A$1210)*($B6='DATABASE '!$B$2:$B$1210),0))=" ","INDEX('DATABASE '!$M$2:$M$1210,MATCH(1,($A$1='DATABASE '!$K$2:$K$210)*($B5='DATABASE '!$L$2:$L$120),0))",INDEX('DATABASE '!$D$2:$D$1210,MATCH(1,($A$1='DATABASE '!$A$2:$A$1210)*($B6='DATABASE '!$B$2:$B$1210),0)))
I'm Looking for the value w/c I can put in the colored Blue Quotation mark, so that it will use/activate the formula in the red colored condition.
P.S not an excel pro, I'm not familiar with all the excel functions. Cheers!!
Please help me.
Many thanks!!!
6 Replies
Use "", not " " (the latter is a string consisting of a space).
HansVogelaar, I Already tried that before, I just put a space to make it visible 🙂
Could you attach a small sample workbook demonstrating the problem?
