Excel VLOOKUP to Calculate Distances using Latitude & Longitude
Channel: LearnAccessByCrystal
Date: 2012-03-30

This is VLOOKUP Week! ... a tradition started by Bill "MrExcel" Jelen, who has a YouTube channel called BJELE123 with great videos for learning Excel.  When Bill asked me to do a VLOOKUP video, I was quite honored as I usually make videos for Access and Windows Phone development.  This was fun! ... and is proof that I actually can make a video in a day ... a very long day ... maybe next time I'll show to convert VLOOKUP equations to Access :) ... or use them in Access -- but that would not efficient since relating data is something Access is designed for.

This VLOOKUP video calculates distance between coordinates using VLOOKUP to get Latitude and Longitude from a table of Zip Codes, which is available as a free download on my website.

There is also Concatenation, Errors (of course) and how to fix them, Relative and Absolute References, Range Names, Transposing, VBA, Table Styles, Formatting, and Conditional Formatting.

~~~~~
LINKS

GetDistance Function for Latitudes and Longitudes
http://www.rogersaccesslibrary.com/forum/getdistance-function-for-latitudes-and-longitudes_topic604.html

Bill's YouTube channel:
http://www.YouTube.com/bjele123

My Reference Database
http://www.accessmvp.com/strive4peace/Reference.htm

My Code Documenter for Access
http://www.accessmvp.com/strive4peace/CodeDocumenter.htm

Call to Excel Gurus: VLOOKUP Week
http://vlookupweek.wordpress.com/excel-gurus/

happy learning!

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!
http://msaccessgurus.com 

I look forward to hearing from you ~

warm regards,
crystal

Remote Programming & Training -- connect to me, let's built it together

~ have an awesome day ~