translating LOOKUP from VBA into excel formula

Question

i have a formula that looks like this in VBA:

ActiveCell.FormulaR1C1 = "=LOOKUP(""ETG_C"",RC[-10],RC[-8])"

what would be the exact equivalent of this if i simply input it into the worksheet?

BradC · Accepted Answer · 2010-05-18 18:28:56Z

1

You would likely have "normal" cell references like "A1" instead of less common relative reference "RC[-10]" (which means 10 columns to the left on the current row)

So it would look something like:

=LOOKUP("ETG_C",B1,D1)

or whatever the correct cells were.

Edit: If you want to keep the relative reference style, then all that would change would be the double quotes:

=LOOKUP("ETG_C",RC[-10],RC[-8])

edited May 18, 2010 at 18:28

answered May 18, 2010 at 18:13

BradC

40.3k14 gold badges77 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alex Gordon Over a year ago

i dont want to do it implicitly, i want to keep the -10 and -8 syntax thanks!

Collectives™ on Stack Overflow

translating LOOKUP from VBA into excel formula

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related