Syntax - set variable to result of Vlookup
What ever is returned by the vlookup. If it will be a string, then use
string, but change the + to &
if they will return numbers, then dim it as double or long depending on
whether it will be decimal number or not.
--
Regards,
Tom Ogilvy
"GettingThere" wrote in message
...
Excellent. I had spent waaay to much time assuming that I had the
myVariable/vlookup part wrong!
One more question if I could - are myVariable1 and myVariable2 declared as
a
strings then, or must they be a variant?
Thanks so much... I do appreciate it!
"Tom Ogilvy" wrote:
MyResult = Evaluate(myVariable1) + Evaluate(myVariable2)
--
Regards,
Tom Ogilvy
"GettingThere" wrote in message
...
I need some syntax help please.trying to set a variable to the result
of
this
vlookup formula:
myVariable = "=IF(ISERROR(VLOOKUP($E2,mySheet!myNamedRange, " &
myVariablePositon & ",FALSE)),0,VLOOKUP($E2,mySheet!myNamedRange," &
myVariablePositon & " ,FALSE))"
I've tried various forms of WorksheetFunction.Vlookup & can't get it.
I
could replace the variable myVariablePosition to a specific column
number,
but it is important to me to return a zero in the event of an error.
Ultimately, I want to do something like:
For i = 2 to lstrow
myVariable1 = "=IF(ISERROR(VLOOKUP($E2,mySheet!myNamedRange, " &
myVariablePositon1 & ",FALSE)),0,VLOOKUP($E2,mySheet!myNamedRange," &
myVariablePositon1 & " ,FALSE))"
myVariable2 = "=IF(ISERROR(VLOOKUP($E2,mySheet!myNamedRange, " &
myVariablePositon2 & ",FALSE)),0,VLOOKUP($E2,mySheet!myNamedRange," &
myVariablePositon2 & " ,FALSE))"
myResult = myVariable1 + myVariable2
cells(i,6) = myResult
Next i
Thanks in advance!
|