Hi, hoping someone can help
If I have the following data as an example
| City | Test | Result |
| London | A | 10 |
| London | B | 15 |
| London | C | 7 |
| Manchester | A | 5 |
| Manchester | C | 9 |
| Leeds | C | 7 |
| Leeds | A | 5 |
| Leeds | B | 12 |
| Leeds | D | 14 |
| Coventry | B | 8 |
| Coventry | C | 7 |
and i have a combo box for city and another for test
if i dropdown a city e.g. leeds and coventry and dropdown test e.g. a - what would be the formula for the corresponding 'result' value?
