Try:
=INDIRECT(x) INDIRECT(y)
(My first try was =INDIRECT(x&" "&y) , but this gives #VALUE! )
lily wrote:
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 as
variants and get the price directly the variants. As you may know, we
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 some
clues.
--
lily
------------------------------------------------------------------------
lily's Profile: http://www.excelforum.com/member.php...o&userid=33150
View this thread: http://www.excelforum.com/showthread...hreadid=529626