Associate
- Joined
- 23 Apr 2007
- Posts
- 1,785
- Location
- Cardiff-ish, Wales
Hi guys,
I've got a list of projects that each have a long comments field.
The projects are listed in cells A1:A10
What I want to be able to do is to click on one of the projects eg A4 and for the comments to be pulled into another cell such as B1.
I can do this easily enough with a vlookup based on a single dropdown list of the projects, but I've no idea how to do it by activating ie selecting a cell. Can this be done?
I've got a list of projects that each have a long comments field.
The projects are listed in cells A1:A10
What I want to be able to do is to click on one of the projects eg A4 and for the comments to be pulled into another cell such as B1.
I can do this easily enough with a vlookup based on a single dropdown list of the projects, but I've no idea how to do it by activating ie selecting a cell. Can this be done?
![A[L]C](/styles/overclockers/avatars/7.png){kind=avatar}