Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup
Thanyou both for your replys. Thats great.
Regards Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) |