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