CODEWITHSUNDEEP
excel
tim r
tim r

Reputation: 89

vlookup with wildcard not working

I'm working with a few large spreadsheets and I can't seem to get vlookup to work.

Here is what I'm trying to do - in the spreadsheet I'm working on I need excel to look at Column B for the item code (09-K1450V/XXXL for example). Then look at a different sheet in column AM for a similar item code and finally spit back the color.

VLOOKUP(B4539&"*",MARKETING!AM3:AM5428,71,FALSE)

Now the only issue (but wildcard should be taking care of this) is that on my Marketing sheet the item codes look like "09-K1450" without the size or anything else.

Upvotes: 0

Views: 1049

Answers (1)

tim r
tim r

Reputation: 89

Scott Craner had the answer:

=VLOOKUP(LEFT(B4539,FIND("V",B4539&"V")-1) & "*",MARKETING!C3:DX5429,69,FALSE)

Upvotes: 1

Related Questions