pricing help
2) LOOKUP w/INLINE ARRAYs
Of you don't want to maintain a separate table on your sheet, you can build
the table into a Lookup formula. Again, remember the first array of wood
types must be alphabetical for this to work properly.
=LOOKUP(A5,
{"Ash","Birch","Cedar","Maple","Oak","Redwood"},{1 0,12,11,9,9.50,14})
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"james" wrote:
hi everyone, i'm a cabinet maker trying to make life a bit easier for myself.
i'm trying to make a sheetto price wood by area.
so i have a cell (a5) with a dropdown list to select wood type
b5 is length
c5 is height
d5 is area (b5 times c5)
e5 i need to be unit price governed by wood type.
eg; if a5=ash then e5=20(wood price)
f5 will be d5 times e5,
its the unit price part i'm stuck on.
can anyone help?
thanks
James
|