Download Excel File: https://excelisfun.net/files/EMT1795-1797.xlsx
Buy excelisfun new book at Mr Excel Web Site: https://excel.bookstore.ipgbook.com/microsoft-365-excel–the-only-app-that-matters-products-9781615470709.php
Buy excelisfun new book at Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Learn how to convert words such as First, Second and Thirds, to numbers such as 1, 2 and 3..
Topics:
1. (00:00) Introduction
2. (00:20) XLOOKUP solution
3. (01:09) XMATCH solution
4. (01:48) XMATCH Spilled Array Formula solution
5. (02:31) VLOOKUP Old School solution
6. (02:59) MATCH Old School solution
7. (03:31) Summary
8. (03:41) Closing, Video Links