Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add multiple values in an array based on multiple hits? | Excel Discussion (Misc queries) | |||
RENEWED-- Arrays: Counting multiple values within array | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
Extract one numerical value from single cell with multiple values? | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) |