size1 size2 size3
shoe1 22 24 26
shoe2 32 34 36
shoe3 42 44 46

Like above shoe pricing sheet, I want to set row and column labels a
variants and get the price directly the variants. As you may know, w
can get the price of size3 shoe2 price by =(size3 shoe3) in any cell
But if you let x=size3, y=shoe3, =(x y) doesn't work. Give me som
clues

--
lil
-----------------------------------------------------------------------
lily's Profile: http://www.excelforum.com/member.php...fo&userid=3315
View this thread: http://www.excelforum.com/showthread.php?threadid=52962