Copying a vlookup cell to multiple cells in same row(most common methods not working)

My function is:

=IFERROR(VLOOKUP(B2,Sheet3!A2:B336,2),"")

I tried the common copy format techniques like clicking/dragging the bottom right black box and even just manual copy+paste into cells in the same row.

I don't want the formula copied as:

Cell Below:
=IFERROR(VLOOKUP(B2,Sheet3!A3:B337,2),"")
Cell below:
=IFERROR(VLOOKUP(B2,Sheet3!A4:B338,2),"")

What I'd like is this:
First cell:
=IFERROR(VLOOKUP(B2,Sheet3!A2:B336,2),"")
Second cell:
=IFERROR(VLOOKUP(B3,Sheet3!A2:B336,2),"")
Third cell
=IFERROR(VLOOKUP(B4,Sheet3!A2:B336,2),"")

So on and so forth for 336 or so cells.

Any ideas on how to copy in the format I want without manual plug n chug for 300+ cells? I tried absolute values, but maybe I did them wrong.

Highlight Sheet3!A2:B336 and hit F4 or replace your table with Sheet3!$A$2:$B$336