Thread: Extract multiple values from array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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.

Reply With QuoteReply With Quote