I've been working on this one for a bit with no success. I've outlined what I'm trying to accomplish below:
Currently, the return works very well, but only with exact matches, everything else throws me an ERROR. I tried modifying the match_type which causes me to throw an error for some reason. What am I doing wrong?
Here is my current formula:
Currently, the return works very well, but only with exact matches, everything else throws me an ERROR. I tried modifying the match_type which causes me to throw an error for some reason. What am I doing wrong?
Here is my current formula:
Code:
=IF(ISBLANK('Quoting Form'!$F$8), "???", IFERROR(INDEX('Motor Data'!$S$10:$S$15,MATCH('Quoting Form'!$D$8,INDEX('Motor Data'!$T$10:$X$15,,MATCH('Quoting Form'!$D$4,'Motor Data'!$T$9:$X$9,0)),0)),"ERROR"))