david tan
New Member
Joined: Jul 17, 2020
Follow
RE: Vlookup on any word within a sentence
Dear Mynda, I follow your formula =INDEX($E$3:$E$4,SUMPRODUCT(ISNUMBER(SEARCH($D$3:$D$4,A3))*ROW($1:$2))) As i add more row to data and lookup ...
5 years ago