How to pull all values instead of first value

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

 

[Gary''s Student]

Use AutoFilter:

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

 

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

 

[Gord Dibben]

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

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

May get you on the track you need.


Gord Dibben MS Excel MVP