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