Forum Discussion
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...
Have you tried advanced filter?
JKPieterse Yes, I have. It returns either all the data or a few items that don't contain the information I'm looking for. Could that be because the information is within a string of text?