Hello master of excel. Anyone help me?
I make index match multi colum like in this picture here 2014-12-08_203252.png
with formula =INDEX($A$2:$A$237;MATCH(K3&L3&M3;$B$2:$B$237&$G$2:$G$237&$H$2:$H$237;0)) , green fonts are the results that K3&L3&M3 are in database, red fonts (#N/A) are the results that K3&L3&M3 are not match with database. I ask how to ignore the not match result without fill anything ("")? so not the #N/A result.
Here the sample example3.xlsx

Many thanks, sir