I have a large data set (87,000+ lines). There are duplicates in the data, so VLOOKUP will not work, and I've been using INDEX/MATCH. I've been running into A LOT of issues.
I got the following formula to work - kinda.
=IFERROR(INDEX('[Historic Lead Data_2019 09...