Reference A Located Cell

[Tubtech]

In the sample workbook provided I used the Formula =CELL("address",INDEX($B$4:$D$15,MATCH("AB109",$B$4:$B$15,0),3)) to locate the cell containing the Department of employee AB109. It provides me with that location correctly, it displays $D$12, My question is now that I have that cell location, I want to reference it from another cell. For example: I want F15 to equal the contents of that located cell. Any way of doing this?

[TMS]

Try:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Tubtech]

Thanks TMS that worked for step one of my project! One more question please, Is there a way in the worksheet provided to have "Due" pasted from column E (No matter what cell in that column its typed) into L6, However if "Due" in column E is changed to an amount update that value to L6? Thanks again, looking forward to your response.

[TMS]

You're welcome.

Try:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Tubtech]

Thanks once again, but is there a way to accomplish this without summing the column, just putting that one value into L6? Last question I promise.

[TMS]

... but is there a way to accomplish this without summing the column, just putting that one value into L6?

If there is nothing else in the range, probably. If it is the last value in the range, probably. If it is one among many, you probably need VBA.

[Tubtech]

Ok thanks TMS i REALLY appreciate the help.

[TMS]

You're welcome. Thanks for the rep.


Last, or only, value in the column:

Please Login or Register  to view this content.

[TMS]

Going back to the original question, why do you go round the houses to get the department for an employee? Why do you need the cell address?

You could just use:

Please Login or Register  to view this content.