Find all Lookup functions in Excel

Find all Lookup functions in Excel

Lookups (and VLOOKUP in particular) are commonly used, useful functions in Excel. However, there is a risk in using these lookups i.e.

  • Using an approximate match when an exact match should be used
  • Not sorting the database in ascending order when using approximate
  • Not including the entire range
Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors