The Door Styles are in a dropdown list in Column A7 on the order form, I have a dropdown for the species in Coumn B7 that both referecece my data sheet. What I need is the formula that finds DW1 then sees the species filter and finds that price and returns it. Thanks!
Door Style Knotty Alder Clear Alder Poplar Rustic Walnut Rustic Cherry
DW1 $204.88 $281.30 $232.15 $296.23 $292.25
DW2 $220.50 $299.10 $177.30 $220.70 $216.50
DW3 $203.00 $277.25 $158.75 $197.50 $193.75
DW4 $203.00 $277.25 $158.75 $197.50 $193.75
DW5 $234.25 $315.75 $191.75 $238.25 $233.75
DW6 $228.00 $316.75 $187.25 $241.50 $236.25
DW7 $208.00 $288.05 $165.15 $210.10 $205.75
DW8 $195.50 $275.55 $152.65 $197.60 $193.25
DW9 $233.63 $321.65 $192.70 $246.18 $241.00
DW10 $170.50 $250.55 $127.65 $172.60 $168.25
Bookmarks