I saw Gord's post after I posted my answer. I interpreted the C1, C2 and C3
as column headers for columns 1, 2 and 3. If that is not correct then my
answer is probably garbage.

--
Regards,

OssieMac


"Gord Dibben" wrote:

Columns are lettered across as A, B, C etc.

There is no column C1, C2, C3

C1 is the cell address of the intersection of column C and Row 1

C2 is the cell address of the intersection of column C and Row 2

With these facts in mind please re-post with a description of your layout and
what you need done.


Gord Dibben MS Excel MVP

On Thu, 27 Mar 2008 20:59:00 -0700, Mudman
wrote:

I have 3 colunms of values, and at the bottom in different cells three cells
that represent the values and below that a formula cell.
I want to be able to click on any value in column C1 and have that value
show up in the cell below. The same with columns C2 and C3, if that value is
selected then that will appear in the formula cells. So if you click in the
column C1 on the 6 it will appear in the cell below and then can be used in
the formula. If you click on a box in C2 it will appear in the next cell and
same with C3.
I know it is possible, just cannot figure out how to get it done.
Thanking you for your help!

C 1 C 2 C 3

2 25 100
4 26 101
6 24 102
8 27 103
10 28 104
12 29 105
14 30 106
16 31 107




C1_______
C2_______
C3_______

equals _______