Formula help

[Craig]

I need a formual that will give me a reult when I enter in the date and
hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
would like a formula in cell A3 to return a value of 56. Is this possible?
Thanks for any help.




Date/ Hour 1 2 3 4 5 6 7 8 9 10 11 12
0 1 25 49 73 97 121 145 169 193 217 241 265
1 2 26 50 74 98 122 146 170 194 218 242 266
2 3 27 51 75 99 123 147 171 195 219 243 267
3 4 28 52 76 100 124 148 172 196 220 244 268
4 5 29 53 77 101 125 149 173 197 221 245 269
5 6 30 54 78 102 126 150 174 198 222 246 270
6 7 31 55 79 103 127 151 175 199 223 247 271
7 8 32 56 80 104 128 152 176 200 224 248 272

[Don Guillett]

Have a look in the help index for INDEX

--
Don Guillett
SalesAid Software
[email protected]
"Craig" <[email protected]> wrote in message
news:[email protected]...
>I need a formual that will give me a reult when I enter in the date and
>hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
>would like a formula in cell A3 to return a value of 56. Is this possible?
>Thanks for any help.
>
>
>
>
> Date/ Hour 1 2 3 4 5 6 7 8 9 10 11 12
> 0 1 25 49 73 97 121 145 169 193 217 241 265
> 1 2 26 50 74 98 122 146 170 194 218 242 266
> 2 3 27 51 75 99 123 147 171 195 219 243 267
> 3 4 28 52 76 100 124 148 172 196 220 244 268
> 4 5 29 53 77 101 125 149 173 197 221 245 269
> 5 6 30 54 78 102 126 150 174 198 222 246 270
> 6 7 31 55 79 103 127 151 175 199 223 247 271
> 7 8 32 56 80 104 128 152 176 200 224 248 272
>
>

[Kevin Vaughn]

With sample table in a1:m12, 3 in a12 and 7 in b12, this formula seemed to
work:

=INDEX($A$1:$M$9,MATCH(B12,$A$1:$A$9,0),MATCH(A12,$A$1:$M$1,0))


--
Kevin Vaughn


"Craig" wrote:

> I need a formual that will give me a reult when I enter in the date and
> hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
> would like a formula in cell A3 to return a value of 56. Is this possible?
> Thanks for any help.
>
>
>
>
> Date/ Hour 1 2 3 4 5 6 7 8 9 10 11 12
> 0 1 25 49 73 97 121 145 169 193 217 241 265
> 1 2 26 50 74 98 122 146 170 194 218 242 266
> 2 3 27 51 75 99 123 147 171 195 219 243 267
> 3 4 28 52 76 100 124 148 172 196 220 244 268
> 4 5 29 53 77 101 125 149 173 197 221 245 269
> 5 6 30 54 78 102 126 150 174 198 222 246 270
> 6 7 31 55 79 103 127 151 175 199 223 247 271
> 7 8 32 56 80 104 128 152 176 200 224 248 272
>
>
>