VLOOKUP and INDEX-MATCH

VLOOKUP and INDEX-MATCH formulas are among the most powerful functions in Excel. Lookup formulas are hand-on whenever you want to have. Excel automatically return the price, product ID, address, or some other associated value from a table based on some lookup value. The Vlookup function can be used when the lookup value is in the left column of your table or when you want to return the last value in a column. The INDEX and MATCH functions can be used in combination to do the same thing, But to provide greater flexibility without some of the limitations of VLOOKUP. l have also learned HLOOKUP, CHOOSE, EXACT, ISBLANK, ISNUMBER, and ISTEXT Functions.

VLOOKUP and INDEX-MATCH

  2     36    

Published : Jun 1st 2018


Related Course