VLOOUP formula - easy way to copy it in the column cells

[fotodj]

I wrote a formula which allows me to auto-propagate next cell (F100) based on info in the table array R1:S108 =IFERROR(VLOOKUP(E100,R1:S108,2,FALSE),"") but when I try to copy it in cells below by dragging (plus sign) then
E100 value changes to E101, E102 and so no but also arrays values change to R2:S109, R3:S110 etc. which will cause errors, is there a workaround to avoid that issue?

 

[SanjayGMusafir]

You probably need absolute referencing

Check this -

=IFERROR(VLOOKUP($E100,$R$1:$S$108,2,FALSE),"")

 

[fotodj]

Perfect! Works.

 

[SanjayGMusafir]

Perfect! Works.

Glad to help you