I need to extact values from an array when there may or may not be multiple
matches to a column value in the array. VLOOKUP does not work because it only
extracts the first match. Is there a way to do this without resorting my
existing array?

I am using Excel '07.