Thread: 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 =A6
3 =A6
4 =A6
5 =A6
6 ----------30-------
7 =A6
8 =A6
9
10
11
12

Regards Robert

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


"RobcPettit@yahoo.co.uk" 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
>
>

=3DVLOOKUP(5,A1:M12,6)

HTH

Die_Another_Day
RobcPettit@yahoo.co.uk 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 =A6
> 3 =A6
> 4 =A6
> 5 =A6
> 6 ----------30-------
> 7 =A6
> 8 =A6
> 9
> 10
> 11
> 12
>=20
> Regards Robert

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

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

Regards

Thanyou both for your replys. Thats great.
Regards Robert