Excel, partial search for Vlookup

zelle132007 · zelle132007's Computer Specifications

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.

ExcelChamp · ExcelChamp's Computer Specifications

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.

zelle132007 · zelle132007's Computer Specifications

Thank you for your help, I have since created an array that utilizes such a procedure.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find partial match from column A,B and fill partial match in C?	Tacrier	Microsoft Excel Misc	4	24th Oct 2008 11:24 PM
Can a partial class inherit from a partial class?	bradw2k	Microsoft C# .NET	3	28th Sep 2006 07:18 PM
Why? Partial Class within a Partial class	Billy	Microsoft ASP .NET	2	1st Feb 2006 10:10 AM
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP(	=?Utf-8?B?T3Nv?=	Microsoft Excel Worksheet Functions	2	26th Jan 2005 07:56 AM
How to make a Partial Search Query or partial search function	=?Utf-8?B?TGUgVHJhbg==?=	Microsoft Access Getting Started	4	15th Jun 2004 09:43 PM