Hi,

Can anyone tell me if you can use "2 dimensional" named ranges? So, for
example, if you had cells B1:D1 named UK, FR, CH respectively and A2:A4
named Car, Boat, Train, is there a way to reference programatically (and or)
manually the value of D4 by using "Train,CH" (or some equivilent).

I understand the use of Offset, but was wondering if there is a direct
method.

Thanks

John