Why your lookup says #N/A
Trailing spaces, text-vs-number mismatches and IFERROR — the three-step debug.
This lesson is part of Pro
Module 1 of every course is free forever. Pro unlocks every other module of every course, removes ads, and adds workbooks and certificates.