Thursday, 14 August 2014

vlookup match formula in excel

vlookup match formula in excel:

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:
    vlookup match formula in excel

     

0 comments:

Post a Comment