Forum Discussion
426_hemi
Feb 26, 2024Copper Contributor
Excel column showing with #ADR
Hello, I have an issue on a user's computer where the same Excel file works fine on mine but on the user's side it shows with "ADR! instead of the actual text. The Office version is the same as o...
Riny_van_Eekelen
Feb 26, 2024Platinum Contributor
426_hemi What formula is in those cells?
426_hemi
Feb 26, 2024Copper Contributor
=@IF(@INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE)="","",INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE))