Hi Everyone,
I have an excel sheet that contains a lot of data on Sheet1
On Sheet2 I have a list of lets say names.
How do i do a vlookup or match on this?
I mean the names on Sheet2 ColumnA will check the names on Sheet1 Column B.
I want the whole data on Sheet 1 captured and copied on Sheet2 (If theres a match)
Could you guys advise? Thanks.
Last edited by Andrew.Trevayne; 02-11-2011 at 02:49 AM.
On sheet2 cell B1 put this formula, then copy down/across as needed:
=INDEX('Active Directory Users'!C:C, MATCH($A1, 'Active Directory Users'!$B:$B, 0))
You'll need to put more data over in the first sheet before you can really see it work.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This is perfect sir. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks