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)
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)