Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] RobcPettit@yahoo.co.uk[_2_] is offline
external usenet poster
 
Posts: 80
Default lookup

Hi, if i have a table of numbers, eg a times table laid out with
numbers 1 to 12 across and 1 to 12 down. How do i look to see, when
selecting say, 5 along the top line and 6 in the first column, were
these cross and what the answer is. Hope that makes sense.
1 3 3 4 5 6 7 8 9 10 11 12
2 ¦
3 ¦
4 ¦
5 ¦
6 ----------30-------
7 ¦
8 ¦
9
10
11
12

Regards Robert