Here I thought of compiling a learning series covering the basics to classics of Excel Lookup functionality. So I have divided them into parts organized in some logically organized fashion. However, you are free to access and learn them in any order. Part 1: Introduction to VLOOKUP Part 2: VLOOKUP: Approximate match example Part 3:... Continue Reading →
Introduction to VLOOKUP in MS Excel
Hi friends… one of the important features of Excel which every user of Excel is expected to be aware of, is VLOOKUP function. Here I take you through the nuts and bolts of VLOOKUP: What does VLOOKUP do ? VLOOKUP function looks up (searches) a value in one column and then returns the corresponding value... Continue Reading →