B
Bob Bob
I use many work sheets all set up the same way just with different values.
Cell A1 is a model #(2000) & Cell B1 is a type or style( XLR). Each work
sheet has a unique model & type.
The rest of the worksheets are set up as follows
Column A (from Cell A2 to A25) have sizes for height A2 is 15" A4 is 17"
ect.
Row 2 (B to Z) is also sizes but for width B2 15", C2 17" and so on.
I then use the work sheet to find out prices
example Model 123 Style XLR with size 17"W x 17"H is on my first worksheet
and has a price of $1.20 which I would find in cell C4.
I want to create a new worksheet where I input the variables and it finds
the price
A1 would be Mod 2000, need B1 would be Type C1 would be width & D1 would be
height. I need a formula for cell E1 that would find the particular price
from all the other worksheet from the info I entered.
Thanks to all in advance.
Cell A1 is a model #(2000) & Cell B1 is a type or style( XLR). Each work
sheet has a unique model & type.
The rest of the worksheets are set up as follows
Column A (from Cell A2 to A25) have sizes for height A2 is 15" A4 is 17"
ect.
Row 2 (B to Z) is also sizes but for width B2 15", C2 17" and so on.
I then use the work sheet to find out prices
example Model 123 Style XLR with size 17"W x 17"H is on my first worksheet
and has a price of $1.20 which I would find in cell C4.
I want to create a new worksheet where I input the variables and it finds
the price
A1 would be Mod 2000, need B1 would be Type C1 would be width & D1 would be
height. I need a formula for cell E1 that would find the particular price
from all the other worksheet from the info I entered.
Thanks to all in advance.