Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add multiple values in an array based on multiple hits? Steve in Columbia Excel Discussion (Misc queries) 12 September 10th 07 01:14 AM
RENEWED-- Arrays: Counting multiple values within array Trilux_nogo Excel Worksheet Functions 5 April 20th 07 01:30 AM
Array: Counting multiple values within array Trilux_nogo Excel Worksheet Functions 4 April 16th 07 03:12 AM
Extract one numerical value from single cell with multiple values? cszy67 Excel Worksheet Functions 2 July 27th 05 02:49 AM
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"