Excel, partial search for Vlookup


Joined
Jul 14, 2010
Messages
5
Reaction score
0
I'll spare you the details, but I believe that what I need to do is use a vlookup with range false for only a specific portion of the look up value, i.e. only the first 6 letters of the look up value looking for an exact match. Any Ideas??

I can provide the long winded gritty details if you really want them.
 
Ad

Advertisements

Joined
Aug 5, 2010
Messages
2
Reaction score
0
Not sure I quite understand the situation, but in the file you are looking up values you could create a new column and extract the first 6 characters of the lookup value (i.e unique identifier) using this formula "=left(B1,6)" and then use the vlookup on that column.
 
Ad

Advertisements

Joined
Jul 14, 2010
Messages
5
Reaction score
0
Thank you for your help, I have since created an array that utilizes such a procedure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top