VLOOKUP not returning correct cell

[divster27]

I've got a number of tabs on a spreadsheet, on one i have some details of records, artist, title catalogue number etc - and i want to match the catalogue number on sheet 1, to the catalogue number on sheet 2, returning the Image URL from the matching row in sheet 2

I'm using vlookup, that may not be the best, but i thought it would work.

Column P has the cat number
i want to match it to to cat number in WHILESAL tab, column C and return the URL value in column M

=VLOOKUP(P1, WHILESAL!$C1:M35000, 11)

C1 to M35000 covers the necessary data array, with M having the URL i want to return - 11 being the 11th column where i want data returned

So i get back the correct format

Site builder | Create your own business or personal website | ownwebsite

ownwebsite's website builder makes it easy to create a blog, website, or online shop. Find modern templates, domains, and easy-to-use tools for any type of website.

www.mywebsite.com

but not the correct jpg location

Easy Website Builder | Web Hosting Included | Ownwebsite.com - which relates to an entirely different record that i can't pick why Excel has chosen that one...

Any suggestions?
David

 

[jasonb75]

Could be because you're using approximate match instead of exact, see if this fixes it.

=VLOOKUP(P1, WHILESAL!$C1:M35000, 11,0)

 

[mart37]

=VLOOKUP(P1, WHILESAL!$C1:M35000, 11,FALSE)

 

[divster27]

thanks again - perfect