vlookup(), match() and offset() in Excel Formula – explained in plain english [spreadcheats]

office 2010 excel ― VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, OFFSET and MATCH worksheet formulas can transform you from normal excel user to a data processing beast.What is the syntax for Match, Vlookup and Offset?Here is the syntax for these three very powerful functions in plain English: What are vlookup () and match () ?VLOOKUP and MATCH are your[...]