lookup and if function for complex question

[Meredith9053]

blinds price lookup.xlsx

Sorry New to Excel. I need a lookup and if formula to return a price for a quote based on a few variables.

Basically need to formula to fill the yellow column. First look at "Type" on Sheet one, If "R" the prices are on Sheet Two, If "v" prices are on sheet three and so on. AFter it determines the Sheet to reference for price list, then i need it to pick up the width and length of the blind and return the price. If need to select the higher figure. Hence if columns are 930 and 1080 and i put 960 it needs to go to 1080 column and so on.

Hope that makes sense. Sorry had to retype as lost my original entry to edit! oops.