I don't know the names ahead of time, only the categories...what I want is a
list of names that are of a specific type...

"Don Guillett" wrote:


=vlookup("bob",sheet2!a2:d33,2,0)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neios" wrote in message
...
I want to look up a value from a column in one worksheet and display the
value from the next column, but in another worksheet. I can do if it is
in
the same worksheet, but the formula doesn't work if I use cell ranges from
another sheet.

ex:
Name Type
Bob A
Joe B
Cindy A

Now in a column on a new worksheet I want to pull all names that fall
under
type A...