VLookup
I am trying to create a multiple v look up formula to calculate the mileage from two destinations. I have a table with a From column, To Column, and miles column with data.
I would like to automatically calculate the mileage determined upon what the user picks as the two destinations from a drop down list. Any suggestions?
I thought it would work like this =VLOOKUP(B5:C5,G3:I14,2) But I'm not sure if I can have a range as the lookup value.
I have attached my sheet I am working from.
Lsiehda
Last edited by lsiehda; 07-09-2009 at 11:26 AM.
Try this,
=SUMPRODUCT(--(G4:G14=B5),--(H4:H14=C5),I4:I14)
Hope this helps,
windknife
You cities in a more standardized mileage chart. This allows you to do the work from any point to any point instead of needing to create special tables for each group.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks windknife, it worked!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks