Vlookup funtionality: I have more than one occurances of the lookup value in my table array.

[Deleted]

My designated table array has multiple results. Vlookup returns only the first match it finds. Is there a way to extract more than one result from my table array? . 

[#2]

Hi Douglas,

In general yes, depends on your data structure. See, for example, https://www.extendoffice.com/documents/excel/2699-excel-vlookup-find-first-2nd-match.html