# VLOOKUP with INDIRECT

A

#### AirgasRob

I would like the formula to reference cell A43 to know which worksheet to go
to and use it as the lookup criteria for VLOOKUP. Below is the formula I have
but it is not working, I am getting #VALUE! as a result.

=VLOOKUP(\$A\$43,INDIRECT("'" & \$A\$43 & "'!" & \$A\$3:\$AB\$30),5,FALSE)

T

#### T. Valko

Try it like this:

=VLOOKUP(\$A\$43,INDIRECT("'" & \$A\$43 & "'!A3:AB30"),5,0)

So, you're looking up the sheet name (A43) on the sheet named in A43? That's

A

#### AirgasRob

Think I am a step closer but now I am getting #N/A

T

#### T. Valko

That means the lookup value can't be found.

Did you note my observation:
you're looking up the sheet name (A43) on the sheet named
in A43? That's what your formula is doing.

Is that what you want to do?

A

#### AirgasRob

Yeah your formula works perfect my lookup was referencing the wrong cell.

=VLOOKUP(\$O\$63,INDIRECT("'" & \$A\$43 & "'!A3:AB30"),5,0)

T

#### T. Valko

Good deal! Thanks for the feedback.