How to store excel formula answer to variable?

[ke9c]

how to set below formula into an variable instead of cell formula?
"=VLOOKUP(RC[-1],Range("A1:A10",3,FALSE)"


i want to do dim i as integer
i="=VLOOKUP(RC[-1],Range("A1:A10",3,FALSE)"

 

[Sandeep Warrier]

Use Evaluate

i = Evaluate("VLOOKUP(Sheet1!A2,Sheet1!A1:C10,3,0)")

Change ranges to suit needs.

 

[ke9c]

Use Evaluate

i = Evaluate("VLOOKUP(Sheet1!A2,Sheet1!A1:C10,3,0)")

Change ranges to suit needs.

thanks, i use below but doesnt work, can advise? srOverrideTicker is a range name
i = Evaluate("VLOOKUP(RC[-1],srOverrideTicker,3,0)")

 

[Sandeep Warrier]

I'm not very familiar with Evaluate()... but I don't think you can use RC[-1] in it. You'll have to replace it with cell names, for example A1.

 

[gsbelbin]

how to set below formula into an variable instead of cell formula?
"=VLOOKUP(RC[-1],Range("A1:A10",3,FALSE)"


i want to do dim i as integer
i="=VLOOKUP(RC[-1],Range("A1:A10",3,FALSE)"

You could use i=WorksheetFunction.VLOOKUP( ...

but I'm not sure that you can use RC[-1]. This is a relative reference, what is it relative to?