VLOOKUP with INDIRECT

  • Thread starter Thread starter AirgasRob
  • Start date Start date
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)
 
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
what your formula is doing.
 
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.
Click to expand...

Is that what you want to do?
 
Yeah your formula works perfect my lookup was referencing the wrong cell.
Thanks for your help!

Should have been this instead.

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