How to reference cells in a named range

[cblechle]

Is it possible to reference specific cells within a named range? EG i have a range named validate=Sheet1:A1:J100 and i want to reference validate A1:A100

 

[Jonmo1]

Welcome to the board...

Try
=INDEX(validate,0,1)

Note, that will error by itself, because it's just a range, it's not doing anthying with it.
It's like writing just
=A1:A100 - doesn't make sense...

You have to then do something with it like...
=SUM(INDEX(validate,0,1))


Hope that helps.

 

[tc88]

Is it possible to reference specific cells within a named range? EG i have a range named validate=Sheet1:A1:J100 and i want to reference validate A1:A100

nevermind, misunderstood question