vlookup issue

I have a formula and it seems to have some issues

the formula i have is

Formula:

Please Login or Register  to view this content.

for my first person it works fine
For my second person it returns the wrong result
form my third person it returns the correct result

I have included a screen shot

Screen.jpg

I actually want to return the data that is on column Q in the products tab but changed it to A to see which result it finds.

could I achieve the same result in another way, I want to keep it as simple as possible as I wont be working with the data.

Originally Posted by AliGW

You need an exact match, not an approximate one:

=VLOOKUP(C6,Products!$A$1:$Q$93,1,0)

thats great thanks for your help, Im sure I did that earlier but its been a long day lol.