Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I set row/column label as variants?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
How do I label a column? | New Users to Excel | |||
Variants vs ranges | Excel Programming | |||
Array Parameters as Variants Only | Excel Programming | |||
Macro - Insert&Label Column, if the labeled column doesn't exist | Excel Programming |