ok this Vlookup values driving me bananas, using Fractions

Thanks for taking the time, I usually get what I need from ChatGPT, but been spending a few hours on this and it's driving me crazy

vlookup.png

ok so very simple, I have a Table that in Row S gives me some data represented in Fraction form.

- I copied S / T over to V/W (Copied Values only)

- In Y, I want to find 1/2 which is the first value and should return user1, however I get #N/A

- If I go to Cell V4 and actually type 1/2 it works.

Please shade some light... Thank you so much!

It looks as though you may have some leading spaces in col V

Oh snap! thank you boss, I used Trim(v4) and got the result.... I can't believe I missed it, I did try Clean(v4) but may had some non-printable characters... (i.e.spaces)

thank you so much!!!!!

You're welcome & thanks for the feedback.