I cannot for the life of me remember how to do this:

I have an array/matrix that looks like this

Red Blue Green Coffee Tea Coke
Red x
Blue y
Green z
Coffee
Tea
Coke

So Red corresponds with coffee, blue with tea and green with coke.

What I'd like is a way for a cell to return the value of it's mirrored
half. In other words, since red-coffee's value is "x", in the column
under red, i'd like there to be an "x" in the cell (row wise that is)
that is coffee-red.

This is a horrible explanation I know. I'm having a hard time trying to
describe what I mean.

It's much like a distance chart on a map. One that you can look to see
how far LA is from Las Vegas, then LA to San Fran, just the same as you
can start at San Fran and trace your finger to see how far it is to LA.

I only want to type in the values once and have the mirrored cell
return that value.


--
hierarchii
------------------------------------------------------------------------
hierarchii's Profile: http://www.excelforum.com/member.php...o&userid=25943
View this thread: http://www.excelforum.com/showthread...hreadid=393211