Here is the formula I am working with:

=IFERROR(VLOOKUP($A10,'P&L MedSci'!$E$5:$T$85,9,FALSE),0)

I want to be able to make that 9 a 10 to reference the next column over. Is there an easy way to replace all the 9's to 10's?

Or a formula so when I drag it over it will only change the col index number?

Thanks for any help!!