Cell address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

psych142 - 28 Nov 2006 16:50 GMT

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

Reply to this Message

Dave F - 28 Nov 2006 16:55 GMT

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

Signature

Brevity is the soul of wit.

> 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

Reply to this Message

psych142 - 28 Nov 2006 16:58 GMT

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

> 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

Reply to this Message

Gary''s Student - 28 Nov 2006 17:16 GMT

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.

Signature

Gary's Student

> 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
[quoted text clipped - 4 lines]
> > I am trying to find a cell adress in a table sized 7 * 53, i am totally
> > stumped please help before my brain explodes

Reply to this Message

psych142 - 28 Nov 2006 17:55 GMT

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

> Select the top, left hand, cell in your table and pull-down:
>
[quoted text clipped - 9 lines]
> > > I am trying to find a cell adress in a table sized 7 * 53, i am totally
> > > stumped please help before my brain explodes

Reply to this Message

Teethless mama - 28 Nov 2006 18:54 GMT

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

> 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

Reply to this Message

psych142 - 28 Nov 2006 21:46 GMT

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

> It sound like VLOOKUP function. Take a look in Excel Help menu
>
> > 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

Reply to this Message