excel function

%3CLINGO-SUB%20id%3D%22lingo-sub-3239565%22%20slang%3D%22en-US%22%3Eexcel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3239565%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%3CBR%20%2F%3EI%20have%20a%20small%20problem%20that%20I%20hope%20you%20can%20help%20me%20with%3CBR%20%2F%3EAs%20shown%20in%20the%20image%20of%20column%20H%2C%20I%20want%20to%20refer%20to%20other%20sheets%2C%20the%20name%20of%20the%20referenced%20sheet%20is%20in%20column%20G%2C%20I%20don't%20know%20if%20there%20is%20a%20general%20formula%20for%20column%20H.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22thangtv23_0-1646196778808.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352280iB90B9B41239C88B0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22thangtv23_0-1646196778808.png%22%20alt%3D%22thangtv23_0-1646196778808.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3239565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3239612%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3239612%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1321521%22%20target%3D%22_blank%22%3E%40thangtv23%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20use%20this%20formula%3C%2FP%3E%3CP%3E%3DINDIRECT(G26%26amp%3B%22!J26%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi guys
I have a small problem that I hope you can help me with
As shown in the image of column H, I want to refer to other sheets, the name of the referenced sheet is in column G, I don't know if there is a general formula for column H.thangtv23_0-1646196778808.png

 

1 Reply

Hi @thangtv23 

You would use this formula

=INDIRECT("'"&G26&"'!J26")