Cell address

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

It sound like VLOOKUP function. Take a look in Excel Help menu

 

[Guest]

i managed using the sumproduct but thanks for the replies