I'm thinking that I'm doing something wrong since I'm very new to Excel. Basically I want to see if any of the LDAP ID listed on sheet 2 are located on sheet 1. I've tried the match and vlookup formulas but I do not see the correct data.
Any assistance would be appreciated.
Here is an implementation of MATCH. Did it both ways.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Hi and welcome to the forum
In D2, copied down...
=IFERROR(VLOOKUP(C2,Sheet2!$A$2:$A$125,1,FALSE),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you so much. I just need to practice this a couple of times.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks