temp = Application.WorksheetFunction.vlookup(b,table,2,0)

"lost!!" wrote in message
...
I get a compile error. Here's how i've typed it in:

Application.WorksheetFunction.vlookup(b,table,2,0)

I have also tried:
Application.WorksheetFunction.vlookup((b),table,2, 0)

Any suggestions?
"N Harkawat" wrote:

Application.WorksheetFunction.VLookup(....

"lost!!" wrote in message
...
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!