I want to write a forumla that will return a value based on both column headings and rows. My table has "Quantities" in the colum headings, i.e >1, >10 and >20 and duration in the row labels, i.e 1 year , 2 years, 3 years etc. I want to put in two values to a cell which are "how many are required" and "how long are they required for" the output value should be able to look up a price in the table based on these criteria. i.e i wish to have a quantity of 15 for a period of 2 years would return the result in the greater than 10 column and the 2 years row. There are only three columns and 4 rows. Please can someone help?
| Min Volume (From) | 1 | 10 | 40 |
| Period | |||
| 1 Year | £10 | £9 | £8 |
| 2 years | £9 | £8 | £7 |
| 3 years | £8 | £7 | £6 |
| 4 years | £7 | £6 | £5 |
| Input Volume = | xx | ||
| input Period = | yy | ||
| Result = | ZZ |
