How do I reference a cell within range?

Depending on how you wanted to reference a cell in that range you could either (as @Alex P wrote) use =INDEX (Age, 5) or if you want to reference a cell in range “Age” that is on the same row as your formula, just use: This mimics the relative reference features built into Excel tables but is an alternative if you don’t want to use a table.
For More Information Please Refer:

You May Also Like to Read: