Hello all !
I may have trouble uploading an excel file here, because I never done that.
Let me try that first.
Basically, if a cell contains a character such as #NA or blank, I would like the resulting cell in the VLOOKUP table as 0.00.
I was able to generate 0.00 in the resulting cell, but it is aligned to the left.
If anyone can help, I would appreciate.
Thank You all.
Dave
Bookmarks