1. Home
  2. Flashcards
  3. Preview

Look Up Functions

  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
Author
clweih01
ID
39135
Card Set
Look Up Functions
Description
Help to Learn Excel Look up functions
Updated

  1. Home
  2. Flashcards
  3. Preview