Variable, pull the same row on a table =[@Ti] turned into ="[@"&C1&"]" I do it all the time with out @ but can´t pull it off with @

General Excel Questions & Answers

Last Post by Mynda Treacy 5 years ago

3 Posts

3 Users

0 Reactions

78 Views

RSS

Pedro Delfin

(@pdelfinwalbro-com)

Posts: 1

New Member

Topic starter

Pls help. Cry Cry Cry Cry Cry

Posted : 25/08/2020 3:59 pm

Philip Treacy

(@philipt)

Posts: 1629

Member Admin

Hi Pedro,

Please read this

https://www.myonlinetraininghub.com/excel-forum/forum-rules-and-guides/read-this-first

You need to attach your workbook so we're not wasting time recreating your data.

Regards

Phil

Posted : 25/08/2020 6:54 pm

Mynda Treacy

(@mynda)

Posts: 4761

Member Admin

Hi Pedro,

Like Phil said, please attach your workbook. It sounds like you're trying to build a cell reference using a formula, but you haven't wrapped it in the INDIRECT function.

Mynda

Posted : 25/08/2020 7:12 pm

26 Forums
7,242 Topics
31.8 K Posts
7 Online
35.2 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Variable, pull the same row on a table =[@Ti] turned into ="[@"&C1&"]" I do it all the time with out @ but can´t pull it off with @

Super Globals

Options and Features