hello,

trying to do the following
for i = 1 to 3
b=1
.....bunch of other actions
=vlookup(##,table,2,0)
b=b+1
next i

how do I get the formula to use B as the cell reference?
my table has this

1 red
2 blue
3 green

I want a different colour to be used each time excel goes through the loop.

Hope you can help!!!

thanks in advance!