Hello all,
I'm trying to use a Substitute function in a Vlookup. The idea is to remove the dashes in the cell I’m looking at before it performs the Vlookup.
Sadly, the formula keeps returning the not found value. I've attached a file that hopefully illustrates my problem.
Thanks for the help,
Chris
Bookmarks