How to pull all values instead of first value
 

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!

How to pull all values instead of first value
 

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!

How to pull all values instead of first value
 

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!

How to pull all values instead of first value
 

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!