finding the source location of a result
 

Hi people I don't know if this is in the right place but I'll give it
shot.

I have created a drop down list which accesses a table, nice and easy
I want to be able to find out the location of the cell in the tabl
that is looked at EG (C9) and not return the result just the location
is this possible? Any information or a guide as where to look would b
appreciated.

Cheers Phad

--
phade2blu
-----------------------------------------------------------------------
phade2blue's Profile: http://www.excelforum.com/member.php...fo&userid=2485
View this thread: http://www.excelforum.com/showthread.php?threadid=38398

finding the source location of a result
 

You have to give more information about what you are looking for.

=ADDRESS(ROW(C9),COLUMN(C9))

The above is one way of making the address display in a cell.

Regards,
Jayant

finding the source location of a result
 

I don't know quite how to put it :rolleyes:

I have two columns on one sheet and two on another.
First sheet two columns labeled ID_Number and ID_Name, ID_name is a
drop down list. Second sheet columns labeled the same but have all the
ID's and Names. The Idea is that when you selecta drop down name on the
first sheet it pulls the ID number accross in two the ID_Number column
on the first sheet. Does this make scence. The Idea is the user only
has to select on item and gets the ID automatically.

Cheers Phade


--
phade2blue
------------------------------------------------------------------------
phade2blue's Profile: http://www.excelforum.com/member.php...o&userid=24852
View this thread: http://www.excelforum.com/showthread...hreadid=383981

finding the source location of a result
 

Not sure if this is what you want, but use the Match function to locate the
result

If cell A1 holds the results of the drop down,
MyList is the name of the table (and the table is only one column)
Than in cell B1:
=Match(A1,Mylist,0)
gives the row number where A1 is located in the list.

If the list starts (in say) row 5 than use
=Match(A1,Mylist,0)+4

If the list is in column C than use:
="C"&Match(A1,Mylist,0)+4
for the address

You could easily build this in code.

Check out "ListIndex" to find the row number in the drop-down list
(but remember that the first ListIndex number is 0, not 1)
--
steveB

Remove "AYN" from email to respond
"phade2blue" wrote
in message ...

Hi people I don't know if this is in the right place but I'll give it a
shot.

I have created a drop down list which accesses a table, nice and easy.
I want to be able to find out the location of the cell in the table
that is looked at EG (C9) and not return the result just the location,
is this possible? Any information or a guide as where to look would be
appreciated.

Cheers Phade


--
phade2blue
------------------------------------------------------------------------
phade2blue's Profile:
http://www.excelforum.com/member.php...o&userid=24852
View this thread: http://www.excelforum.com/showthread...hreadid=383981

finding the source location of a result
 

Check out VLookUp or LookUp functions

or

My all time favorite is
=Index(IDTable,Match(A1,IDNameColumnTable,0),1)

IDTable = reference to 2 columns on 2nd sheet
IDColumnTable = reference to 2nd column in IDTable (IDName)
A1 is the cell holding the result of the drop-down.
The 1 represents pulling the information from the 1st column of IDTable
(IDNumber)

Since your drop-down pulls its list from the IDTable, this shouldn't raise
an error.

--
steveB

Remove "AYN" from email to respond
"phade2blue" wrote
in message ...

I don't know quite how to put it :rolleyes:

I have two columns on one sheet and two on another.
First sheet two columns labeled ID_Number and ID_Name, ID_name is a
drop down list. Second sheet columns labeled the same but have all the
ID's and Names. The Idea is that when you selecta drop down name on the
first sheet it pulls the ID number accross in two the ID_Number column
on the first sheet. Does this make scence. The Idea is the user only
has to select on item and gets the ID automatically.

Cheers Phade


--
phade2blue
------------------------------------------------------------------------
phade2blue's Profile:
http://www.excelforum.com/member.php...o&userid=24852
View this thread: http://www.excelforum.com/showthread...hreadid=383981

finding the source location of a result
 

Thank you very much!! =Index(IDTable,Match(A1,IDNameColumnTable,0),1)
works like a dream. I don't understand it yet :confused: , but I will.
Thanks again.

Cheers Phade :)


--
phade2blue
------------------------------------------------------------------------
phade2blue's Profile: http://www.excelforum.com/member.php...o&userid=24852
View this thread: http://www.excelforum.com/showthread...hreadid=383981

finding the source location of a result
 

Phade,

You're very welcome!

Look up the Index function and the Match function in Excel help.
(It took me years of using this, before I finally understood what
it was doing)...

--
steveB

Remove "AYN" from email to respond
"phade2blue" wrote
in message ...

Thank you very much!! =Index(IDTable,Match(A1,IDNameColumnTable,0),1)
works like a dream. I don't understand it yet :confused: , but I will.
Thanks again.

Cheers Phade :)


--
phade2blue
------------------------------------------------------------------------
phade2blue's Profile:
http://www.excelforum.com/member.php...o&userid=24852
View this thread: http://www.excelforum.com/showthread...hreadid=383981