Cell address

P

psych142

Hi all,

I am trying to find a cell adress in a table sized 7 * 53, i am totally
stumped please help before my brain explodes
 
D

Dave F

Do you know the row and column number of the address you're looking for? Ex.
if row is 10 and column is 1, then =ADDRESS(10,1) returns $A$10.

Is that what you're looking for? If not, please provide some more detail
about what information you want to use to return a cell address.

Dave
 
P

psych142

sorry i should have added more details, the tables contain dates of staff
sickness, i need to find the address of the cell which matches a date which
is contained in another table. hope this helps
 
G

Gary''s Student

Select the top, left hand, cell in your table and pull-down:

Edit > Find and enter the value you are looking for. The found value will
be selected and the row/column highlighted.
 
P

psych142

sorry i am not doing a good job of explaining myself, what i want to do with
the cell address is use the offset command to retrieve the data on a 3rd
table which contains the hours of sickness, this data would be on the same
row but 8 columns along. The large table gets its data directly from the off
duty
 
Top