Look Up Functions

Card Set Information

Author:
clweih01
ID:
39135
Filename:
Look Up Functions
Updated:
2010-10-02 17:32:38
Tags:
Excel look up functions
Folders:

Description:
Help to Learn Excel Look up functions
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user clweih01 on FreezingBlue Flashcards. What would you like to do?


  1. vlookup - is it case sensative?
    No
  2. vlookup: If lookup is smaller than the smallest value in the first column of the lookup range...
    Returns #N/A error value
  3. ISERROR syntax:
    • syntax: =ISERROR(value)
    • -returns T if value refers to any error
    • value
    • Ex. =IF(ISERROR(A1), "An error has occured.", A1*2)
  4. If column number is < 1 then... What is returned? (VLOOKUP)
    VLOOKUP returns a #VALUE! error judgement

What would you like to do?

Home > Flashcards > Print Preview