Hi,
Require assistance with below fomula
1. If cell K2 is blank OR not exact match - Require L2 to be blank
Have below fomula in cell L2
[CODE=IF(ISNONTEXT(FIND($K2,MasterList!$A$3:$A$10001)),INDEX(MasterList!G$3:G$10001,MATCH("*"&$K2&"*",MasterList!$A$3:$A$10001,0)),"")[/CODE]
Tried
=IF(ISNONTEXT(FIND($K2,MasterList!$A$2:$A$10000)),INDEX(MasterList!B$2:B$10000,MATCH("*"&$K2&"*",MasterList!$A$2:$A$10000,0)),"",FIND($K2,MasterList!$A$2:$A$10000)),INDEX(MasterList!B$2:B$10000,MATCH("*"&$K2&"*",MasterList!$A$2:$A$10000,0)))
doesn't work
USING EXCEL 2016
Thanks in advance
Bookmarks