Tag Archives: Crystal Long

Crystal Long Declares: “Not Over Yet… Convert VLOOKUP Equations to MS Access!”

Microsoft Access MVP Crystal Long has Decalred that “VLOOKUP WEEK 2012” is not over yet and has decided to take VLOOKUP in another direction; today Crystal gives us a lesson in Converting VLOOKUP to Equations for MS Access!

“In my last VLOOKUP Week video, I showed you how to make a Distance Table using the VLOOKUP function in Excel. Now, we build the same thing in Access — will show you how to convert VLOOKUP equations to Access.” … To Read More Click Here to go to Crystal Long’s Lesson.

Crystal Long may be found at Strive4Peace as well as on YouTube Learn Access by Crystal

Advertisements

Crystal Long: “VLookup to Calculate Distances using Latitude & Longitude”

From Microsoft Access MVP Crystal Long

“My 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.”  … To Read More Click Here to go to Crystal Long’s Lesson.

 

Crystal Long may be found at Strive4Peace as well as on YouTube Learn Access by Crystal