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
--
bikky
------------------------------------------------------------------------
bikky's Profile:
http://www.excelforum.com/member.php...o&userid=36149
View this thread:
http://www.excelforum.com/showthread...hreadid=559359