Substitute in a vlookup

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

Hi,

Substitute function returns text.
Modify the formula to :

=IF(ISERROR(VLOOKUP(VALUE(SUBSTITUTE(D2,"-","")),A2:B13,2,FALSE)),"Not working arg",VLOOKUP(VALUE(SUBSTITUTE(D2,"-","")),A2:B13,2,FALSE))

Perfect!

Thanks Rubeus_Hagrid,

Chris

Hello people,

i would like to make formula or VBA formula to change every character with his parallel character.
for ex:

if I have table
A B
ž z
š s
ć c
č c

and in C1 have tekst "šećer hoće voće"

I woul like to have in D1 "secer hoce voce"

any idea?