Hi,
I think this should be quite simple... lets hope anyway!
Looking to return multiple values from a single lookup value.
In the attached... populate column M by looking up values in column L from values in row 2 (on both sheets), returning back values in row 1.
As you can see the values in row 2 are not 'identical' but will always start with the value I'm looking up... e.g. I want values corresponding to "A" to return: "A", "A1" "AcF"
(in reality, these will be numbers, so don't worry about the A...AA,AB,AC issue you'd get after 26 rows)
Is it also possible to return them in an array if multiple "A"'s are found (as in the file)? - either returned as the sample arrays below in L14 and L19 - i.e. can we return them adjacent to the search term in multiple columns (L14)... or insert rows to accommodate multiple return values (L19)
Thanks
Bookmarks