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
[ Ссылка ]

Bill's YouTube channel:
[ Ссылка ]

My Reference Database
[ Ссылка ]

My Code Documenter for Access
[ Ссылка ]

Call to Excel Gurus: VLOOKUP Week
[ Ссылка ]

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!
[ Ссылка ]

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 ~

свернуть