Excel 2003 - I am trying to pull all the data that equal a specific value in
another spreadsheet. I first tried to use a vlookup but that only pulled me
the first match. I need to pull all the data that matches the value. Is
there any functions that allow me to do this.

For example: I want all the users who are in the XYZ role instead of just
the first user in that role.

Thanks!

Use AutoFilter:

This will display all the rows that match your criteria. You can then
copy/paste the visible rows.
--
Gary''s Student - gsnu200767


"duketter" wrote:

Excel 2003 - I am trying to pull all the data that equal a specific value in
another spreadsheet. I first tried to use a vlookup but that only pulled me
the first match. I need to pull all the data that matches the value. Is
there any functions that allow me to do this.

For example: I want all the users who are in the XYZ role instead of just
the first user in that role.

Thanks!

I generally use autofilter for small items, however I have a large amount of
items I need to look up. It would be very time consuming to use auto filter
to check each one individually.

Isn't there any functions to automate this?

"Gary''s Student" wrote:

Use AutoFilter:

This will display all the rows that match your criteria. You can then
copy/paste the visible rows.
--
Gary''s Student - gsnu200767


"duketter" wrote:

Excel 2003 - I am trying to pull all the data that equal a specific value in
another spreadsheet. I first tried to use a vlookup but that only pulled me
the first match. I need to pull all the data that matches the value. Is
there any functions that allow me to do this.

For example: I want all the users who are in the XYZ role instead of just
the first user in that role.

Thanks!

Have a look at Ashish's site for how to return multiple values from a VLOOKUP

http://office.microsoft.com/en-us/ex...260381033.aspx

May get you on the track you need.


Gord Dibben MS Excel MVP

On Tue, 5 Feb 2008 11:00:05 -0800, duketter
wrote:

I generally use autofilter for small items, however I have a large amount of
items I need to look up. It would be very time consuming to use auto filter
to check each one individually.

Isn't there any functions to automate this?

"Gary''s Student" wrote:

Use AutoFilter:

This will display all the rows that match your criteria. You can then
copy/paste the visible rows.
--
Gary''s Student - gsnu200767


"duketter" wrote:

Excel 2003 - I am trying to pull all the data that equal a specific value in
another spreadsheet. I first tried to use a vlookup but that only pulled me
the first match. I need to pull all the data that matches the value. Is
there any functions that allow me to do this.

For example: I want all the users who are in the XYZ role instead of just
the first user in that role.

Thanks!