If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Compare two excel sheets - find matches?

Zascar · 2010-07-19 09:42:28

I have two excel lists of customers accounts. What I want to be able to do see which accounts appear on both lists. Is there any way to do this?

19-07-2010 10:42am

#1

Zascar

Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,778 Mod ✭✭✭✭

Join Date: April 2001

Posts: 10513

I have two excel lists of customers accounts. What I want to be able to do see which accounts appear on both lists. Is there any way to do this?

0

Comments

#2 19-07-2010 11:20am

phog

Registered Users, Registered Users 2 Posts: 24,392 ✭✭✭✭

Join Date: January 2006

Posts: 23513

Vlookup should do the trick

0
#3 19-07-2010 12:01pm

dilallio

Registered Users, Registered Users 2 Posts: 2,728 ✭✭✭

Join Date: February 2008

Posts: 2531

The match function will also do the job and is easier than the vlookup for beginners.
If you will be doing a lot of work with comparing data between worksheets though, the vlookup is one of the most useful functions you will use.

0
#4 19-07-2010 12:02pm

Zascar

Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,778 Mod ✭✭✭✭

Join Date: April 2001

Posts: 10513

Cheers guys. If they are not exact matches will it still work?

0
#5 19-07-2010 12:18pm

dilallio

Registered Users, Registered Users 2 Posts: 2,728 ✭✭✭

Join Date: February 2008

Posts: 2531

The match function will return the row number of he found cell if it finds a match. If it doesn't find a match, it will return #N/A.

0