In this video, I demonstrate how to get VLOOKUP to return a value for the last match in a column. VLOOKUP returns a value for the first match it finds, not the last, so how can this be achieved? If the values you are cross-referencing are in ascending order, you can use an approximate… Read More »How to VLOOKUP the Last Occurrence of a Value in a Column | VLOOKUP Last Match
In this video I demonstrate how to calculate whether a result has met a benchmark within a tolerance level. The functions used are ABS and IF. I also demonstrate how to conditionally format a value if falls outside a tolerance level – plus or minus. Click here to download the featured file.
In this video I demonstrate how to categorise text values based on a list of keywords. I have a list of course names. If the course name contains words like Excel or Outlook, I want to categorise the course as a Microsoft course. If the course name contains words like InDesign or Premier, I… Read More »Assign Categories Based on Keywords in Excel | Check if Cell Contains Text From List