OK, in that case I don't know what you mean by
"let x=size3, y=shoe3". My answer assumes that
x and y are named ranges, each of 1 cell, containing
size3 and shoe3 (or whatever).

The formula
=indirect(B1) indirect(A2)
would mean the intersection of the range whose name
or address is in B1, and the range whose name or
address is in A1. So if B1 contains size3 and A2 contains
shoe3, you should get whatever's in the intersection of
those ranges.

If this doesnt help, maybe you could email me a copy
of your workbook so I can understand it better.

Andrew

lily wrote:
I have try =indirect(B1) indirect(A2) in cell, for example, A7, but it
doesn't return to the value intersected by B1 and A2. Thanks for your
help.


--
lily
------------------------------------------------------------------------
lily's Profile: http://www.excelforum.com/member.php...o&userid=33150
View this thread: http://www.excelforum.com/showthread...hreadid=529626