A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

lookup same or similar



 
 
Thread Tools Display Modes
  #1  
Old June 10th, 2009, 09:14 PM posted to microsoft.public.excel.worksheet.functions
Needtoknow
external usenet poster
 
Posts: 55
Default lookup same or similar

Hi all, I have tried to search old messages without luck.

I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need to find vendor from older file ti new file and get
order value there. It doesn't matter if column G = vendor name from old file
and col H order value from old file.

This would be easy with vlookup IF all names were written correctly. Many
people make these and misspelling happens. I have figured something like
this, tell if tjere is easier way.

= IF (vlookup to find excatly same name (lookup to get value) ond if excatly
the same vendor cannot be found, there would be nearest suggestion and that
vendors value ) if not anything even close can be found, excel would informs
something like "check" or like that.

Is it possible to have checking if some vendor is not at all in new file?

That's all this time =) I think. You have been a huge help in past,
hopefully also this case can be solved. I have Excel 2003 in use.
  #2  
Old June 10th, 2009, 09:41 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
 
Posts: 6,167
Default lookup same or similar


If all vendors are known, use a drop down data validation list so user can't
screw it up.
But, I'll bet this doesn't answer. Samples??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NeedToKnow" wrote in message
...
Hi all, I have tried to search old messages without luck.

I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need to find vendor from older file ti new file and
get
order value there. It doesn't matter if column G = vendor name from old
file
and col H order value from old file.

This would be easy with vlookup IF all names were written correctly. Many
people make these and misspelling happens. I have figured something like
this, tell if tjere is easier way.

= IF (vlookup to find excatly same name (lookup to get value) ond if
excatly
the same vendor cannot be found, there would be nearest suggestion and
that
vendors value ) if not anything even close can be found, excel would
informs
something like "check" or like that.

Is it possible to have checking if some vendor is not at all in new file?

That's all this time =) I think. You have been a huge help in past,
hopefully also this case can be solved. I have Excel 2003 in use.


  #3  
Old June 11th, 2009, 03:58 AM posted to microsoft.public.excel.worksheet.functions
JLatham
external usenet poster
 
Posts: 1,896
Default lookup same or similar

The 'fuzzy' logic required here would probably be huge, and would require (in
my opinion) VBA to even begin to straighten out the mess. And it probably
wouldn't fix everything even after much tweaking and cajoling.

Quite possibly the best solution is to do as Don Guillett suggested: Create
a list of valid vendor names and require users to use the dropdown list (via
data validation) to select the vendors.

But before that even begins to help you someone probably simply needs to go
in and brute force the vendor names to their correct spelling and
standardized format. Got an intern handy?

"NeedToKnow" wrote:

Hi all, I have tried to search old messages without luck.

I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need to find vendor from older file ti new file and get
order value there. It doesn't matter if column G = vendor name from old file
and col H order value from old file.

This would be easy with vlookup IF all names were written correctly. Many
people make these and misspelling happens. I have figured something like
this, tell if tjere is easier way.

= IF (vlookup to find excatly same name (lookup to get value) ond if excatly
the same vendor cannot be found, there would be nearest suggestion and that
vendors value ) if not anything even close can be found, excel would informs
something like "check" or like that.

Is it possible to have checking if some vendor is not at all in new file?

That's all this time =) I think. You have been a huge help in past,
hopefully also this case can be solved. I have Excel 2003 in use.

  #4  
Old June 20th, 2009, 01:09 AM posted to microsoft.public.excel.worksheet.functions
Keith Faulconer
external usenet poster
 
Posts: 15
Default lookup same or similar

I am not sure of a function that could do what you are asking. What I would
do is ensure that the entries are the same by havinf the users select the
vendors from a drop down menu. You can list the vendors in a list, then
have the Vendor name be selected from that list.

"NeedToKnow" wrote in message
...
Hi all, I have tried to search old messages without luck.

I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need to find vendor from older file ti new file and
get
order value there. It doesn't matter if column G = vendor name from old
file
and col H order value from old file.

This would be easy with vlookup IF all names were written correctly. Many
people make these and misspelling happens. I have figured something like
this, tell if tjere is easier way.

= IF (vlookup to find excatly same name (lookup to get value) ond if
excatly
the same vendor cannot be found, there would be nearest suggestion and
that
vendors value ) if not anything even close can be found, excel would
informs
something like "check" or like that.

Is it possible to have checking if some vendor is not at all in new file?

That's all this time =) I think. You have been a huge help in past,
hopefully also this case can be solved. I have Excel 2003 in use.


 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.