VLOOKUP almost does what I need, but it won’t retrieve all the numbers associated with a list value that’s in the table multiple times. E.g. for table,
Is there an alternative function to return 1 and 2 for lookup value D? If I had to use a macro, what would it look like?