I'm trying to return a specific value for all cells that are blank when doing a vlookup.
So if I have my one sheet has the following data
A B
1 C 75
2 F 86
3 U
4 I 43
5 Q 49
I want to pull the information on a new sheet, but if it's pulling for U (B3) then I want it to instead of giving a 0 to return with 100. How do I format my formula to do this?
Thanks in advance.
Bookmarks