Forum Discussion
Dominic35
Sep 15, 2022Copper Contributor
cell value
Current have a spread sheet with two tabs, the first is CSV Quoting which i enter all my data (each line is a job), and then i have a template tab to which i i have standard forms - and i need to cha...
- Sep 15, 2022
Dominic35 You need to use INDIRECT.
Try this:
=INDIRECT("'CSV Quoting'!"&E5)where E5 need to contain a text like I93.
Riny_van_Eekelen
Sep 15, 2022Platinum Contributor
Dominic35 You need to use INDIRECT.
Try this:
=INDIRECT("'CSV Quoting'!"&E5)where E5 need to contain a text like I93.
Dominic35
Sep 15, 2022Copper Contributor
thank you... worked..