RLOOKUP - Error Codes

RLOOKUP will return error codes on incorrect formatting as follows:

  • -9991 = No lookup pair found - minimum format should be { threshold , result }
  • -9992 = A lookup pair is incorrectly specified. i.e. it is missing its comma - format should be  { threshold , result ; threshold , result }, you have an extra ; at the end of your lookup list
  • -9993 = A lookup pair has more than two parts. i.e. you have an extra comma
  • 0 = no lookup pair could be found that matched the value

Feedback and Knowledge Base