Russ,

Usually, data filters will show you what you want.

However, if you need to extract the values to another table, you can use an array formula (entered
using Ctrl-Shift-Enter) like:

=INDEX($E$1:$E$10,LARGE(($D$1:$D$10="Test")*ROW($D $1:$D$10),ROW(D1)))

Where E1:E10 has the data you want, D1:D10 has the labels. This formula, as written, will return
the values in the opposite order of how they apear.
Copy down for as many cells as values you expect.

HTH,
Bernie
MS Excel MVP


"Russ B" <Russ wrote in message
...
For vlookup, If there are two or more values in the first column of
table_array that match the lookup_value, the first value found is used. I
have several matches for each lookup value. Which function/functions can i
use to show all the matches under each lookup value.

Thank ou in anticipation!
Russ