From Tom Urtis of Atlas Programming Management, Inc. we have a full page of Lookup Tutorials including VLOOKUP, HLOOKUP, Reverse LOOKUP, Min/Max LOOKUP and more. Thank you to Tom for creating this resource and allowing VLOOKUP WEEK 2012 to share it here – with all of you!
Tag Archives: Advanced VLookup
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.
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.
From Jorge Paulino, Microsoft Visual Basic MVP, an addition to the VLOOKUP WEEK em Português!!
Though not fluent in Português, there is quite a bit of Code associated with this entry so we have designated it Intermediate to Advanced VLookup. We thank Jorge for his contribution. We will, however, leave the commentary on the submission to our Português Speaking viewers.