| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect VLookup | Excel Discussion (Misc queries) | |||
| VLOOKUP WITH INDIRECT | Excel Discussion (Misc queries) | |||
| VLOOKUP & INDIRECT | Excel Discussion (Misc queries) | |||
| Indirect/Vlookup/??? | Excel Discussion (Misc queries) | |||
| Indirect Vlookup with RC[-1] | Excel Worksheet Functions | |||
Linear Mode
