VLOOKUP Not working

[David1948]

I am trying to use a VLOOKUP to bring a value in to sheet 1 to identify if values are in a master list sheet 2. I have uploaded the file. Appreciate knowing why the Vlookup is not working. The common field is MPN_Stripped and there is at least one match that I have highlighted in yellow
Many thanks for any help

[Pepe Le Mokko]

What are you trying to return?
Your lookup table is one column and your vlookup searches values in the 4th column of a one-column tale?

[David1948]

Thanks for interest. I want to use the MPN_Stripped Value in SPIR to find a match in SPD1 (Column 4) and then bring in the Stock No Column 1 .............the item in yellow would be 10225668 against 63142ZC3 Row No 312 (in SPIR)

Hope this is clear

Thanks again

[Pepe Le Mokko]

Try this in D2 and pull down

=INDEX('SPD1'!$A$2:$A$159,MATCH(SPIR!$A2,'SPD1'!$D$2:$D$159,0))

[David1948]

Works perfectly, thanks a lot.............Is VLookUp not appropriate for this example
Many Thanks Pepe

[Pepe Le Mokko]

No, VLOOKUP does not perform left lookups ( in fact it does but it needs some tweaking..). INDEX/MATCH is easier and more understandable.

In the future it is best to add some expected results manually to your example sheet so our members can see if they are on track..

[Pepe Le Mokko]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[David1948]

thanks have done as you suggested I didnt know about this ...Many thanks again