Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Dimensional Array
Mark,
Sounds like you want a Select Case Select Case value Case 0 ' value = 0 result = A.txt, 1 Case 1 result = B.txt, 2 Case 3 .... End Select replace "value" and "result" to fit your needs. I wasn't sure what you meant by A.txt, 1 so you'll have to fix that to. (Don't use the terms value or text or integer since they are reserved words in Excel.) This works like nested if's but is much neater. steve "Mark Frank" wrote in message ... Hi all, I am trying to create a two-dimensional array (kind of like a lookup where columnA references columnB). I.e. I have an integer 0 to 6 If the integer in the loop is 0, return A.txt, 1 then B.txt, 2 then C.txt etc Does anyone have an example of a 2-D array that basically performs like the loop-up above? I do not want to nest if statements, does not look proper. Thanks in adavance, Mark Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup within a 2 dimensional array | Excel Worksheet Functions | |||
2-dimensional array to 2 column list | Excel Discussion (Misc queries) | |||
How do I convert a row of cells into a two-dimensional array? | Excel Worksheet Functions | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) | |||
Sorting a 2-dimensional array | Excel Programming |