Vlookup Week

From ‘Beginning Excel’: “HLOOKUP to Find Resistor Values”

               

Find your Value in the correct Tolerance with HLookup!

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

               

DLookup, DMin, Align controls…? What is this!?

“We’re Going To Need A Bigger Week!”

               

Just when you thought it was safe…

Bill Jelen: “From 1979 – VisiCalc and LOOKUP”!

               

You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back to 1979…VisiCalc and the whole ’20 Functions’ available in that time! There were no IF statements and there was no VLOOKUP…but there was ‘LOOKUP’. Follow along and see where VLOOKUP began! [youtube=http://www.youtube.com/watch?v=wU8WhGtRWF8]

Mike Girvin “VLOOKUP WEEK Double Header Wrap Up!”

               

Mike ‘ExcelisFun’ Girvin has produced Tutorials each day this week for the VLOOKUP WEEK 2012 effort. In this post, Two (2) Videos Tutorials from Mike! VLOOKUP WEEK 2012 Tutorial #5: “CHOOSE Function – Beginner to Advanced with 12 Examples” “Unlike other lookup functions, CHOOSE lets you lookup “things” besides values: Text, Numbers, Formulas, Functions, Cell(…)

Learn Excel from MrExcel