Forum Discussion

justinmalecha's avatar
justinmalecha
Copper Contributor
Nov 17, 2023
Solved

Linked workbook formula

I am wondering if there is a way to build a formula for a workbook link in excel. For example, I would like the highlighted area to reference cell E1 instead of having that text telling excel where t...
  • Lorenzo's avatar
    Nov 17, 2023

    Hi justinmalecha 

     

     

    in B3:

    =INDIRECT("'" & E1 &"'!" & E2 & "[Sltlo Total (lbs)]")

Resources