Hi! You guys have been so great in helping me set up this function and it has worked beautifully so far. I've run into a snag though.
I've double-checked all the arrays and references and can't for the life of me figure out WHY it is returning #N/A in this spreadsheet when it works in all others?
I did not sort anything before, I tried to be sure to have the first cell above the referenced lookup and whatever else I needed to do.
I'm stumped! Any ideas?
Thank you so much once again!
Bookmarks