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 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

Excel Problem!

jester77 · 2007-04-05 07:54:58

I've 2 excel sheets. One is a long list containing names with other details. The second sheet just contains a list of names. I need to be able to extract a sublist of the first sheet that match the names from the second. Is this possible using excel or would I need to write a small program for it?

05-04-2007 7:54am

#1

jester77

Registered Users, Registered Users 2 Posts: 11,264 ✭✭✭✭

Join Date: October 2003

Posts: 10879

I've 2 excel sheets. One is a long list containing names with other details. The second sheet just contains a list of names. I need to be able to extract a sublist of the first sheet that match the names from the second. Is this possible using excel or would I need to write a small program for it?

0

Comments

#2 05-04-2007 8:14am

Evil Phil

Registered Users, Registered Users 2 Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

You can do it in excel. Have a look at vlookup in the help file, that should get you started.

0
#3 05-04-2007 8:50am

jester77

Registered Users, Registered Users 2 Posts: 11,264 ✭✭✭✭

Join Date: October 2003

Posts: 10879

Evil Phil wrote:

You can do it in excel. Have a look at vlookup in the help file, that should get you started.

Nice one, thanks!

0