Look Up Functions
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
vlookup - is it case sensative?
vlookup: If lookup is smaller than the smallest value in the first column of the lookup range...
Returns #N/A error value
- syntax: =ISERROR(value)
- -returns T if value refers to any error
- 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
Home > Flashcards > Print Preview