Using Indirect to keep cell reference from changing

[craigg3]

I have a vLookup that im using but when rows get deleted it changes my cell reference. Im not sure how to apply Indirect formula into my exisiting formula.

I start with:
=IFERROR(VLOOKUP($T$1-2,Job!$A$1:$AB$500,147,FALSE),"--")

But after a few deletes I get this:
=IFERROR(VLOOKUP($T$1-2,Job!$A$1:$AB$493,147,FALSE),"--")

I want to keep my reference from A1 to AB500

 

[Taul]

Hi Try this
Cell A2 = $A$1:$AB$500

Change the formula to

 =IFERROR(VLOOKUP($T$1-2,INDIRECT("Job!"&$A$2),3,FALSE),"--")

 

[craigg3]

Hi Try this
Cell A2 = $A$1:$AB$500

Change the formula to

 =IFERROR(VLOOKUP($T$1-2,INDIRECT("Job!"&$A$2),3,FALSE),"--")

Works great, thank you!