How to pull all values instead of first value

D

duketter

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

Gary''s Student

Use AutoFilter:

This will display all the rows that match your criteria. You can then
copy/paste the visible rows.
 
D

duketter

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