Vlookup question

[Rob Etherington]

i have on sheet1 a list of reference data in two columns. column a)
has a part code in it and column b) has a piece of data relating to
it.
in a few examples (infact probably the majority of cases) the code in
cell a) is repeated a few times but with different data in cell b) on
each occasion.
is it possible to do a lookup where it finds and brings back data in
column b)on all occasions when a code is found in column a, not just
the first of last?

does that make sense?

cheers

Rob

 

[Frank Kabel]

Hi

you may try downloadind Alan Beban's array functions
(http://home.pacbell.net/beban)
They'll include a function called VLOOKUPS (for returning
multiple
lookup results)

 

[Max]

Why not just do a Data > Filter > Autofilter on col A?

Then you can just click on the part code from the drop list
in A1, and the filtered rows will be exactly what you're
after

And you can also easily copy *just* the filtered rows
elsewhere if necessary via:

Copy > paste special > check "values" > OK

Looks quite perfect for the job.

--

If somehow Autofilter is not an option,
check this link for a possible approach
to a similar previous query:

http://tinyurl.com/yqpdo

http://tinyurl.com/ysjjm
(some finer tweaks)