Hey there people,

This may be a very simple array or LOOKUP formula but my brain doesn’t work like it used to.

If you look at the table above, I am setting up a spreadsheet to look up a figure based of width and height fitting within certain parameters. (This is to do with blinds by the way). If I put in the following: 

WIDTH:  2.2

HEIGHT: 2.6

I would need the formular to not only work out where the number sits (I.e. width is less than 2.5 but more than 2.0 but also that the height is less than 3.0 and more than 2.5) and then LOOKUP to give me a result of $1,095.00 

I’m wondering if the format of the table I have made needs to be reworked so it will be simpler to do.

Any helpful advice is greatly appreciated.

Thanks,

Mr Shady

​Hey there people,This may be a very simple array or LOOKUP formula but my brain doesn’t work like it used to.If you look at the table above, I am setting up a spreadsheet to look up a figure based of width and height fitting within certain parameters. (This is to do with blinds by the way). If I put in the following: WIDTH:  2.2HEIGHT: 2.6I would need the formular to not only work out where the number sits (I.e. width is less than 2.5 but more than 2.0 but also that the height is less than 3.0 and more than 2.5) and then LOOKUP to give me a result of $1,095.00 I’m wondering if the format of the table I have made needs to be reworked so it will be simpler to do.Any helpful advice is greatly appreciated.Thanks,Mr Shady   Read More

​