what if the number of values are different?

I had a feeling that would be the case!

Then it gets real complicated!

See B. R. Ramachandran's reply.

Biff

"tjb" wrote in message
...
what if the number of values are different?

"Biff" wrote:

Hi!

As long as the number of values to return for each lookup_value are the
same, 3:

=INDEX(Sheet2!B$1:B$20,MATCH(A$1,Sheet2!A$1:A$20,0 )+ROWS($1:1)-1,0)

Copy down to B3.

Biff

"tjb" wrote in message
...
I know there has to be a way to do this.

On Sheet1 the user enters in "ABC" into cell A1. Cell B1 would have
something like a VLOOKUP to look at Sheet2 to fill in the data.

Cell B1:B3 should then fill in with a range of data from a separate
list
on
Sheet2

Let's say on Sheet2 there is a list of data that looks something like
this:

ABC 123
456
789
DEF 012
345
678

I hope this makes at least a little sense to at least one of you out
there...