Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USing Match on 2D array
Technique demo'd from the immediate window:
v = Evaluate("{1,""A"";2,""B"";3,""C"";4,""D""}") ? v(1,1) 1 ? v(1,2) A ? Application.Match("C",Application.Index(v,0,2),0) 3 -- Regards, Tom Ogilvy "ExcelMonkey" wrote: Can someone please remind me how to use match on a 2d array ("OrigViewNames") if i am looking to return the position of a value (x) in the second column of the array. This does not work: Application.Match(x, OrigViewNames, 0) What do I have to put after the OrigViewNames to indicate column 2. Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH() on a 2D array? | Excel Discussion (Misc queries) | |||
Match using array of column and row references to match with | Excel Worksheet Functions | |||
array match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Match as well as does not match array function | Excel Discussion (Misc queries) |