jonsharman
New Member
- Joined
- Jan 4, 2014
- Messages
- 28
Hi All,
I am trying to return a monetary value using INDEX MATCH based on two criteria that will search through a range of data - example of the sheet below:
<tbody>
</tbody>
I have named the ranges CO2, P and D and in the above example I want to return the figure £20.00 based on looking for the value 116 which exists between 110 - 119 in the CO2 range and the P range. Likewise if I was to search for 135 and and D I would want to return £150.00
I have tried using TRUE to search for a near match but I get a #N/A error and I just cannot see what I am doing wrong.
Any help would be appreciated.
Thanks
I am trying to return a monetary value using INDEX MATCH based on two criteria that will search through a range of data - example of the sheet below:
DATA | LOOKUP | RETURN | |||||
CO2 | P | D | 116 | P | £20.00 | ||
0 - 99 | £10.00 | £0.00 | |||||
100 - 109 | £15.00 | £15.00 | |||||
110 - 119 | £20.00 | £20.00 | |||||
120 - 129 | £115.00 | £90.00 | |||||
130 - 139 | £175.00 | £150.00 |
<tbody>
</tbody>
I have named the ranges CO2, P and D and in the above example I want to return the figure £20.00 based on looking for the value 116 which exists between 110 - 119 in the CO2 range and the P range. Likewise if I was to search for 135 and and D I would want to return £150.00
I have tried using TRUE to search for a near match but I get a #N/A error and I just cannot see what I am doing wrong.
Any help would be appreciated.
Thanks