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