Using $ to hold column when dragging using a datasource

[djfatboyfats]

Good morning,

When I create a formula and want to hold the range I just put $ signs around the range to hold it however I'm unable to do this if I'm using a data range, how do you hold the data range column for dragging?

Example I want to hold the column

Please Login or Register  to view this content.

from the code below but I'm unable to do so which means when I drag the formula across it gives me the next column in the data source table instead of Fullname which is what I need.

Please Login or Register  to view this content.

Thanks in advance

DJ

[TMS]

Assuming that you're talking about a Structured Table, you'd need to do something like:

Please Login or Register  to view this content.

[TMS]

Marked Solved?

Excuse me. Is that it? You ask a question, it gets answered, you mark it solved and wave goodbye? No feedback, no comment, no thank you, no KMA?

Registered around 10 years, with 400 posts, you should know better.