I have a VLOOKUP formula installed that produces some N/A for names that don't qualify. While I know how to make these not show with an iferror formula is there a way that if another formula is looking up the cell with the VLOOKUP formula in it that it will act like it's a blank and that nothing is there?
It keeps picking up the original VLOOKUP formula even though nothing it shown, I want it to register as nothing as long as there isn't a correct value being returned so it doesn't mess up my second formula.
I tried Trim, = and a few other things with no luck, it recognizes text in the cell each time.
Any help is greatly appreciated, thanks!
Bookmarks