VLOOKUP with INDIRECT
 

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)

VLOOKUP with INDIRECT
 

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.

--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
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)

VLOOKUP with INDIRECT
 

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

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
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)

VLOOKUP with INDIRECT
 

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?


--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
Think I am a step closer but now I am getting #N/A

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
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)

VLOOKUP with INDIRECT
 

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)



"T. Valko" wrote:

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?


--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
Think I am a step closer but now I am getting #N/A

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
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)

VLOOKUP with INDIRECT
 

Good deal! Thanks for the feedback.

--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
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)



"T. Valko" wrote:

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?


--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
Think I am a step closer but now I am getting #N/A

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"AirgasRob" wrote in message
...
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)