Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# EXCEL 2007

Posted on 2011-03-17
Medium Priority
196 Views
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
0
Question by:happyexchange
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 2000 total points
ID: 35160556
Use the MATCH function. For example:

=IF(ISERROR(MATCH("happyexchange",A:A,0)),"No Match","Match")

Kevin
0

LVL 33

Expert Comment

ID: 35160563
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

jppinto
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns overâ€¦
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month8 days, 19 hours left to enroll