Forum Discussion

Dominic35's avatar
Dominic35
Copper Contributor
Sep 15, 2022
Solved

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...
  • Riny_van_Eekelen's avatar
    Sep 15, 2022

    Dominic35 You need to use INDIRECT.

    Try this:

    =INDIRECT("'CSV Quoting'!"&E5)

    where E5 need to contain a text like I93.

Resources