EXECL Advanced Search to problems

vlookup function, if not found, then return an error value “# n / a”, Can not find the case, return a null value

= IF (ISERROR (VLOOKUP (“Joe Smith”, A:B , 2,0 )),””, VLOOKUP (“Joe Smith”, A:B, 2,0))

Leave a Reply