Another Vlookup on cells that contain formulas (Sorry)

[afcmRamos]

Hi all Excel Gurus,

I have search/read some topics here on the forum, regarding Vlookup on cells that contain formulas, but I'm not able to solve my Excel Vlookup formula.

I have several Vlookup formulas and they are working perfect based on a Text Value. But when I try to use the Vlookup based on a result of another Vlookup it doesn't work. Also I'm not sure if Vlookup is able to work with values returned from other formulas.

I'm using office 365.

I have attached one Excel file example, anyone com have a look ?

41.8 KB file on MEGA

mega.nz

Thanks for the help.

Regards,
ARamos

 

[saboh12617]

Hello,
It's because your values are not consistent. You are mixing weird "∕" with the normal "/". They are not the same caracters so your functions wont find them
I suggest you to replace them all by another caracter, for instance "_". I chose this one because "/" was converting to dates, and "." was making numbers. you will find attached the corrected file. Always be careful on the caracters with strings, as you could notice if you look closely, those two slashes were different.

edit nvm i can not upload the file, just do a find and replace with the caracters i mentioned.

 

[SunnyAlv]

look below, "/" different

slashes have different characters from those on the keyboard, so Vlokup becomes an error, how to solve it : change the “/” slash in Sheet “C” Column “A” to “/” slash same with Sheet "B"

result if u change it

 

[afcmRamos]

Thanks all for your help.

I didn't notice that difference.

After replacing the different characters it's working perfect now.