Lookup formulas look up values in tables. Think of it as searching for a name in the telephone directory.
Example:
VLOOKUP( B2, TelData, 2, FALSE )
means lookup the value B2 in TelData, and return the 2nd column of TelData, ASSUMING a row has been matched. Setting the fourth argument to FALSE, means find an EXACT MATCH.
No comments:
Post a Comment