Page 264 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Allows safely extending or collapsing the lookup table by inserting or deleting columns and rows.

No limit to the lookup value’s size.
Works faster. Because an Index Match formula references columns/rows rather than an entire table, it requires
less processing power and won’t slow down your Excel.
For more information, please check out:

INDEX MATCH as a better alternative to VLOOKUP
INDEX MATCH formula for two-dimensional lookup
Excel Lookup comparison table

As you see, not all Excel Lookup formulas are equivalent, some can handle a number of different lookups while
others can only be used in a specific situation. The table below outlines the capabilities of each Lookup formula
in Excel.

251

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77