how to make a vlookup with multiple conditions

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
768
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?



ProvinceDistancePrice
ON5KM$5
ON10KM$10
Quebec5KM$15
Quebec10KM$20

<tbody>
</tbody>
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
You are welcome.
 

Forum statistics

Threads
1,085,489
Messages
5,383,960
Members
401,868
Latest member
herbalgirlskincare

Some videos you may like

This Week's Hot Topics

Top