When extending formula across table, formula loses ref point

IF(B2<13.5,"",VLOOKUP(B2,SpD Text Lookup::A$1:B$6,2,close-match))

Your formula, when filled to the right will increment all of the column references one column to the right for each column the formula is filled into.

Example: If the formula above is entered as shown in B4, then filled right three cells to E4, it will read:

IF(E2<13.5,"",VLOOKUP(E2,SpD Text Lookup::D$1:E$6,2,close-match))

The REFerence error likely is due to the table, SpD Text Lookup, having only four columns.

The likely cure is to remove the $ operator from the row value (where it is needed only if you are filling down (or up) and place it before the column value ($A and $B)

Normal practice is also to make your lookup table with only as many columns and rows as needed, then reference the full columns (excluding header and footer rows if any have been set), specifying only the column letters.

Your formula would then become:

IF(B2<13.5,"",VLOOKUP(B2,SpD Text Lookup::$A:$B,2,close-match))

Regards,

Barry