<div>
You want to get the rest of the data when you find a match of the name? You can use a VLOOKUP() function to do that but without more information all I can do right now is show you an article about the use of this function:<br />
<br />
<a href="http://excel-user.blogspot.com/2009/10/vlookup-get-value-based-on-another.html" rel="ugc">http://excel-user.blogspot.com/2009/10/vlookup-get-value-based-on-another.html</a><br />
<br />
jppinto
</div>


You want to get the rest of the data when you find a match of the name? You can use a VLOOKUP() function to do that but without more information all I can do right now is show you an article about the use of this function:

http://excel-user.blogspot.com/2009/10/vlookup-get-value-based-on-another.html [http://excel-user.blogspot.com/2009/10/vlookup-get-value-based-on-another.html]

jppinto

<div>
<div class="content wysiwyg-content">
Hi ive been a report from HR on all staff memebers currently working in te company. Ive just exported all users from AD.<br />
<br />
Is there a formual in Excel 2007 Where i can match the names. Cause there are loads more names in AD then there is in this report.<br />
I have over 400 names which i ned to match up.<br />
<br />
So for exampe if i had happyexchange in the report how do i do a formula to match it up. &nbsp;Thank you for all your help
</div>
</div>


Hi ive been a report from HR on all staff memebers currently working in te company. Ive just exported all users from AD.

Is there a formual in Excel 2007 Where i can match the names. Cause there are loads more names in AD then there is in this report.
I have over 400 names which i ned to match up.

So for exampe if i had happyexchange in the report how do i do a formula to match it up.  Thank you for all your help

EXCEL 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.