bikky Wrote:
DAV,

Pick your brains a bit more on matrix idea please.....

using formula
=OFFSET(Matrix!$A$1,MATCH(B18,Matrix!1:1,0),MATCH( C18,Matrix!A:A,0))


is giving me 1 row and 1 col. out so eg

a1 a b c d
a 0 12 7 9
b 12 0 15 6
c 7 15 0 16
d 9 6 16 0


and the lookup is "a b" which should give the result 12, but i'm
getting 15, one col along, plus one row down, and this is for every
one.

Any ideas where its gone wrong?


Thanks again


for the time being i've used
=OFFSET(Matrix!$A$1,MATCH(B18,Matrix!a1:a50,0),MAT CH(C18,Matrix!b1:Az1,0))

this gives me 50 sites in each direction, but still would like to know
how to do it with full row/column reference, rather than fixed
column/row references if anyone knows


--
bikky
------------------------------------------------------------------------
bikky's Profile: http://www.excelforum.com/member.php...o&userid=36149
View this thread: http://www.excelforum.com/showthread...hreadid=559359