Home
Flashcards
Preview
Look Up Functions
Home
Get App
Take Quiz
Create
vlookup - is it case sensative?
No
vlookup: If lookup is smaller than the smallest value in the first column of the lookup range...
Returns #N/A error value
ISERROR syntax:
syntax
: =ISERROR(value)
-returns T if value refers to
any
error
value
Ex. =IF(ISERROR(A1), "An error has occured.", A1*2)
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
2010-10-02T21:32:38Z
Show Answers
Home
Flashcards
Preview