MSExcel

And the winner of the VLOOKUP Great White Shark Award is…

               

JP Pinto!  Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week.  He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week. …To(…)

From The MS Office Blog: “VLOOKUP WEEK 2012 Wrap-Up”

               

From the Blog.Office.Com Excel Blog page, Microsoft’s Emily Warn puts the Wraps on “VLOOKUPWEEK 2012” “VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside–Excel experts created a crazy number of useful and(…)

From ‘Smitticisms’: “IF Statements and LOOKUPS”

               

 Smitty writes: “This article will focus on the appropriate use of IF statements, and also show you when it’s better to move into more robust formulas like LOOKUP, VLOOKUP, HLOOKUP & INDEX/MATCH.”  …To Continue on with Smitty’s Tutorial click here .

Tom Urtis at Atlas Programming Management Inc: “LOOKUP Page”

               

VLOOKUP Resources from Tom Urtis

Tom Urtis: “Lookup First and Last Values Along Row”

               

“When you are faced with a table that is scattered with values among empty cells, you might need to know the first (left-most) or last (right-most) value in that row. In the following picture, the first value in the row is returned by the formula =INDEX(D2:H2,MATCH(TRUE,INDEX((D2:H2<>0),0),0)), copied down as needed.” …To Read More Click Here(…)

Learn Excel from MrExcel