Forum Discussion
Megpie
May 29, 2019Copper Contributor
Vlookup to find multiple variations of a text string and return column
This is what I have so far: =VLOOKUP("*"&$H$2&"*", Datatable, COLUMN(A2), FALSE) $H$2 = Contains the text I'm searching for within Datatable When I run the formula, I only get the first i...
JKPieterse
May 29, 2019Silver Contributor
Have you tried advanced filter?