solracesoj
Board Regular
- Joined
- Oct 25, 2002
- Messages
- 144
Hello again!
I have the following problem:
Is it possible to have a formula in cells C10, C11, C12 and C13, that automatically detects the values in the table. For example, in row 10 I have X1 and Y1, which means the value 10 in the table, but I want it to appear in cell C10. How can I do this automatically.
I would appreciate any kind of tips to deal whith tables in Excel.
Thanks once again!
J.C.
I have the following problem:
Verificação para pilares - Diâmetro 40.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | X1 | X2 | X3 | X4 | X5 | X6 | |||
3 | Y1 | 10 | 20 | 30 | 40 | 50 | 120 | ||
4 | Y2 | 15 | 50 | 60 | 41 | 100 | 60 | ||
5 | Y3 | 20 | 80 | 90 | 42 | 150 | 0 | ||
6 | Y4 | 25 | 110 | 120 | 43 | 200 | -60 | ||
7 | Y5 | 30 | 140 | 150 | 44 | 250 | -120 | ||
8 | Y6 | 35 | 170 | 180 | 45 | 300 | -180 | ||
9 | |||||||||
10 | X1 | Y1 | 10 | ||||||
11 | X3 | Y1 | 30 | ||||||
12 | X6 | Y6 | -180 | ||||||
13 | X4 | Y5 | 44 | ||||||
14 | |||||||||
Sheet1 |
Is it possible to have a formula in cells C10, C11, C12 and C13, that automatically detects the values in the table. For example, in row 10 I have X1 and Y1, which means the value 10 in the table, but I want it to appear in cell C10. How can I do this automatically.
I would appreciate any kind of tips to deal whith tables in Excel.
Thanks once again!
J.C.