Jumat, 03 April 2015

Re: [ExcelVBA] Re: VLookup??

 

=IFERROR(VLOOKUP(B67,MailList!$A$2:$F$600,2,FALSE), " ")

I enter the last name and each column thereafter fills in from that.  
 

From: "yahoo@grugeon.com.au [ExcelVBA]" <ExcelVBA@yahoogroups.com>
To: ExcelVBA@yahoogroups.com
Sent: Friday, April 3, 2015 2:51 PM
Subject: [ExcelVBA] Re: VLookup??

 
Hi Sharron

There are several approaches.  One would be to have a key column consisting of lname & fname.

It would look  like PuryearSharron and reference to this.  It is still possible there will be duplicates though.  Other solutions would need vba.

You could put a cell on your form using something like 

=Countif(lname range, cell where surname is) then make this cell invisible when the value<2 but have a red fill otherwise.

This would just alert you to problems when the name was Smith.

Without knowing how the form is filled in it is difficult to be more precise.

Regards
Davidg Grugeon


__._,_.___

Posted by: Sharron Puryear <sheizageek@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Posting Komentar