Extract multiple values from array
 

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.

Extract multiple values from array
 

Look he

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"vpinnell" wrote in message
...
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.

Extract multiple values from array
 

Excel 2007 PivotTable
Multiple lookup values.
No formulas or code needed.
http://www.mediafire.com/file/nlmmaf...10_27_09c.xlsx