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

lookup
 

=VLOOKUP(5,A1:M12,6)

HTH

Die_Another_Day
wrote:
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

lookup
 

Dim c as Long, r as Long, rng as Range
c = 5
r = 6
set rng = intersect(columns(c),rows(r))
msgbox rng.Address & " - " & rng.Value

--
Regards,
Tom Ogilvy


" wrote:

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

lookup
 

Have you considered the Intersection Operator? It works on name
ranges;

for example "=(RowName ColumnName)" returns the cell at th
intersection of that row and column. The operator is simply the spac
between the names.

Regard

--
Ny
-----------------------------------------------------------------------
Nyq's Profile: http://www.excelforum.com/member.php...fo&userid=3538
View this thread: http://www.excelforum.com/showthread.php?threadid=55149

lookup
 

Thanyou both for your replys. Thats great.
Regards Robert