Hello,
I am looking what I believe to be a formula with index and match, but cant figure it out. What I am looking to do is create a spreadsheet for my window business that can look up prices for me instantly
I have 4 columns: EXAMPLE
window type ; height ; width ; price
SH ; 24 ; 36 ; $100
SH ; 24 ; 50 ; $200
SH ; 30 ; 36 ; $150
SH ; 30 ; 50 ; $250
i need a formula that compare the window type, the height and width and then spit out the price. the problem is i need the height and width to be variable, meaning if a window is 26 x 36 it will give me the 30 x 50 price ; if its 24 x 38 it will give me the 24 x 50 price...obviously i will have more window types than SH so I need that to be exact match and the height and width to be ranges and spit out the price i need. Can someone help me with this formula?
Thanks in advance!
Bookmarks