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?
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?