Forum Discussion
Fomula issue
Hi All, Can someone take a look at my formula and help me understand why the cells in column L is not taking the information correctly? Could it be a formatting problem? Thank you in advance. ...
Bahama85 Try this:
=IFERROR(INDEX(Q:Q,MATCH(1,($B:$B=N6)*($A:$A=O6)*($K:$K=P6)),1),"")
I believe you were missing "(" directly before $B:$B and also an extra ")" directly after P6 to close out the match function, lastly, the zero should be a 1 to indicate the column number of the original array.
I believe that was it. Now I get an error message that states "Inconsistent calculated column formula"
Bahama85 That just means that the same calculation is not in all rows within the table. If you copy and paste in all rows that should disappear.
Cool, got that far but nothing is showing up as expected in the cells. No errors in the cells.
 
 
Bahama85 Okay, that last zero in your formula , if you recall, needed to be a 1 instead of zero which designates the index column of the array.
You're making progress. 🙂