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

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
--
Brevity is the soul of wit.


"psych142" wrote:

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

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

"psych142" wrote:

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

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.
--
Gary's Student


"psych142" wrote:

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

"psych142" wrote:

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

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

"Gary''s Student" wrote:

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.
--
Gary's Student


"psych142" wrote:

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

"psych142" wrote:

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

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


"psych142" wrote:

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

i managed using the sumproduct but thanks for the replies :)

"Teethless mama" wrote:

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


"psych142" wrote:

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