dragging down formula with vlookup and iferror not working

Hello, so I am trying to get this tricky formula to work with vlookup and if error. The problem is that excel will not recognize the formula when I try to drag it down, but instead repeats the same numbers over again. I've tried some combinations using vlookup, rows, and if error, but it doesn't seem to work. So I'm trying to drag down the formula from g3:g99, to reference either cells b8:99, or whichever value I enter into f1, on down to b99. If someone could help, that would be wonderful. I've attached a sample of the problem I'm working with. Thanks for taking the time to look!

Sounds like the Calculation Options are set to Manual on the Formulas Tab.

Put this formula in G3:

=IFERROR(VLOOKUP($F$1+ROWS($1:1)-1,$A$3:$B$99,2,FALSE),1)

then copy down.

Hope this helps.

Pete

Thank you both so much!! Life savers!