Posted on August 14, 2014 by Unknown
vlookup match formula in excel:
" VLOOKUP MATCH is an improved version of your basic VLOOKUP or INDEX MATCH formula."
Need of vlookup match:
Using VLOOKUP MATCH allows you to perform a matrix lookup – instead of just looking up a vertical value, the MATCH portion of the formula turns your column reference into a dynamic horizontal lookup as well.
VLOOKUP MATCH is mainly useful for situations where you intended to perform heavy editing on your data set after you’ve finished writing your formula.
VLOOKUP MATCH gives your lookup formula insertion immunity; whenever you insert or delete a column within your lookup array, your formula will still pull the correct number.
Working:
0 comments:
Post a Comment