Spreadsheet: 815076d1674730926-formula-to-overcome-ref-reference-error-gk-working-file-2-
Sheet: Sheet1

this is what is in A1
this is what is in A2
This is what is in A3 |  |  |  | XXX: 99 [NAME] X&X |  |  |  |  | XXX: 99 XXXX X&X
This is what is in A4 |  |  |  | [NAME]: [NAME] |  |  |  |  | [NAME]: 9
This is what is in A5
This is what is in A6 |  |  |  |  | XXXXX_XX     :- |  |  | [NAME] :-99/99/9999 |  | XXXXXXXY XXX:  999999.99
This is what is in A7 |  |  |  |  | XY/XX/XX/XXX :-9/99/99/999 |  |  | [NAME] :- |  | XXXX_XXX_XXXX :- 99/99/9999
This is what is in A8 |  |  |  |  | XXXXXX       :-XXX |  |  | [NAME]   :-
This is what is in A9 |  |  |  |  | XXX-XYXX     :- |  |  | [NAME]      :-
This is what is in A10 |  |  |  |  | [NAME]  :-99 |  |  | [NAME]  :-99/99/9999 |  |  | XX.X/X XXXX: 9.99
This is what is in A11
This is what is in A12 |  | [NAME] | [NAME] | XXXXXXXX | [NAME] | [NAME] | [NAME] | XXX-XXXXXX | XXXX-XXXXX | [NAME] | XXXXX-XXXY | [NAME] | XX-XXXXXXX | [NAME] | [NAME]
 | XXXXXX |  | XX-XXXXX | XX-XXXXX | [NAME] | [NAME] | XX | XXXXXY-XXX | [NAME] | XYXX-XXX-9 | [NAME] | XYXX-XXX-9 | XX-XXX-XXX | XX-XXX-XXX | XXY-XXX-XXX
 |  | XXXX | X-XXX | X-XXX | [NAME] | [NAME] | XX% | X/X-XXXXXX | XXXXX-XXXX | [NAME] | XXXX-XXXX | XXXX-XXXX | XXXXX-XXXX | XXXXX-XXXX | [NAME]
 |  | X/X | XXX-XXXX | XXX-XXXX | XXXXX XXXXXX |  | X-XXX | XXX% | X-XXX | XX | XX | XX | [NAME]
-----------------------------------------------------------------------------------------------------------------------------------------------------------
XXX,99 |  | 99 | 99 | 9 |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9.99
XXX XXX,99 | [NAME] |  | 9 | 9 |  |  |  | 9 |  |  |  |  | 9 | 9 | 9.99
 |  | 99 | 9 |  |  |  | % | 9 | 9 | 9 | L19 of sheet 1 | 99-99-9999 | 9 | 9 | 9.99
 |  | 9 |  |  | 9 |  |  |  | 9 |  |  |  | 9
XXX,99 |  | 999 | 99 | 999 | 9 | 9 |  | 9999 | 999.9 | 9 | 9999.99 | 9 | 9 | 9 | 99999.99
[NAME] | [NAME] |  | 9 | 9 | 9 | 9 |  | 9999.99 | 99-99-9999 | 99999 |  |  | 9 | 9 | 99999.99
 |  | 99 | 9.9999 | 9.9999 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | -99999.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
[NAME] |  | 999 | 999 | 999 | 9 | 9 |  | 99999 | 999.9 | 9 | 9999.99 | 9 | 9 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 9999.99 | 99-99-9999 | 99999.99 |  |  | 9 | 99999 | -99999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | -9.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 9999 | 999 | 999 | 9 | 9 |  | 99999 | 9999.9 | 9 | 9999.9 | 9 | 9 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 9999.9 |  |  |  |  | 9 | 9 | 9.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | 99999.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 9999 | 9999 | 9999 | 9 | 9 |  | 99999 | 9999.99 | 9 | 99999.99 | 9 | 9 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.9 | 99-99-9999 | 999999 |  |  | 9 | 9 | 999999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | 999.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 9999 | 9999 | 9999 | 9 | 9 |  | 99999 | 9999.9 | 9 | 99999.99 | 9 | 999.99 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.99 | 99-99-9999 | 99999 |  |  | 9 | 9 | 99999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | -9.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 99999 | 9999 | 9999 | 9 | 9 |  | 99999 | 9999.9 | 9 | 99999.9 | 9 | 9.99 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.9 | 99-99-9999 | 99999 |  |  | 9 | 9 | 99999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | 9.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 99999 | 99999 | 9999 | 9 | 9 |  | 99999 | 99999.9 | 9 | 99999.99 | 9 | 9 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.99 |  |  |  |  | 9 | 9 | 9.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | 99999.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 99999 | 99999 | 9999 | 9 | 9 |  | 99999 | 9999.9 | 9 | 99999.99 | 9 | 9 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.9 | 99-99-9999 | 999999 |  |  | 9 | 9 | 999999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | 9.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 99999 | 99999 | 9999 | 9 | 9 |  | 99999 | 9999.9 | 9 | 99999.99 | 9 | 999.99 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.99 | 99-99-9999 | 99999 |  |  | 9 | 9 | 99999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | -9.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9
XXX,99 |  | 99999 | 99999 | 9999 | 9 | 9 |  | 99999 | 9999.99 | 9 | 99999.99 | 9 | 9 | 9 | 99999.99
XXX XXX,99 | [NAME] |  | 9 | 9 | 9 | 9 |  | 99999.9 | 99-99-9999 | 99999 |  |  | 9 | 9 | 99999.99
 |  | 99 | 9 | 9 | 9 | 9 | 0.99 | 9 | 9 | 9 | 99-99-9999 | 99-99-9999 | 9 | 9 | -999.99
 |  | 9 | 9 | 9 | 9 |  | 9 |  | 9 |  | 9 | 99 | 9