adding cell locations

J

joe smith

How do I add cell locations? For instance, I have gotten cell $A$21 from a lookup function, but I want the next cell down. ie. the lookup gives me $A$21 and I want to get the next cell down from that ($A$22).
 
F

Frank Kabel

joe said:
How do I add cell locations? For instance, I have gotten cell $A$21
from a lookup function, but I want the next cell down. ie. the
lookup gives me $A$21 and I want to get the next cell down from that
($A$22).

Hi Joe
try
=OFFSET($A$21,1,0)

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top