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...
VLOOKUP with last argument of FALSE always returns the first instance. To return the last instance, LOOKUP is the best. To return any instance between the first and the last, INDEX-AGGREGATE would return your desired result, including the first and the last.