PDA

View Full Version : match supplier name in form with standard supplier name



Pravina
10-09-2017, 05:07 AM
We received forms from consumer with supplier name. & we have standard supplier name list.
we use vba code to copy FER form details to our database automatically. but i'm unable to use this vba code as consumer is not using standard supplier name.

eg. if standard supplier name is Telx Group. then some customer use Telx. some use The Telx Group.Some use Telx America.

provide vba code to update standard name in database.

Bob Phillips
10-09-2017, 03:44 PM
provide vba code to update standard name in database.

What, no hint of please, could someone help, this is what I tried. Just ... do this for me!

Pravina
10-10-2017, 05:46 AM
'=VLOOKUP(AU8&"*"&AV8,CHOOSE({1,2},AQ1:AQ233&AR1:AR233,AS1:AS233),2,0)
i want forumal like that in excel vba


Supplier
60 Hudson Owner LLC
Entity



AAPT Ltd.
Australia



AIMS Data Centre Sdn. Bhd.
Malaysia



Alaska Communications
er



Arteria Networks Corporation
Japan



AT&T
er



ATM S.A.(Atman)
er



Azzurro HD LLC
er



Bayan Telecommunications, Inc.
er



BCEBCE NEXXIA INC.
Canada



Belgacom International Carrier
er



Bell Canada
Canada