PC Review


Reply
Thread Tools Rate Thread

Excel, partial search for Vlookup

 
 
New Member
Join Date: Jul 2010
Posts: 5
 
      14th Jul 2010
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.
 
Reply With Quote
 
 
 
 
New Member
Join Date: Aug 2010
Posts: 2
 
      5th Aug 2010
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.
 
Reply With Quote
 
 
 
 
New Member
Join Date: Jul 2010
Posts: 5
 
      5th Aug 2010
Thank you for your help, I have since created an array that utilizes such a procedure.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:02 PM.