A vlookup with one condition is simple enough. How would I do a vlookup to get me the cost of smth in the province of Ontario that is 10 KM away?
<tbody>
</tbody>
Province | Distance | Price | |||||||
ON | 5KM | $5 | |||||||
ON | 10KM | $10 | |||||||
Quebec | 5KM | $15 | |||||||
Quebec | 10KM | $20 | |||||||
<tbody>
</tbody>