Can vlookup handle more than one match, if so how?

[DavidObeid]

I have a spreadsheet that has a list of (not necessarily continuous
dates (in sheet2, column A), with comments on the dates in column B.

My problem is as follows:

In sheet2 Column A there are sometimes occasions where a date might b
listed twice (because 2 events take place on that day).

I have the following vlookup function on sheet1 of my spreadsheet:

=IF(ISERROR(VLOOKUP(B4,Sheet2!$A:$D,2,FALSE))=TRUE,"",VLOOKUP(B4,Sheet2!$A:$D,2
FALSE))

How can I modify this function to concatenate multiple entries on th
same date?

Thanks in advance,

Dav

 

[Paul]

I have a spreadsheet that has a list of (not necessarily continuous)
dates (in sheet2, column A), with comments on the dates in column B.

My problem is as follows:

In sheet2 Column A there are sometimes occasions where a date might be
listed twice (because 2 events take place on that day).

I have the following vlookup function on sheet1 of my spreadsheet:

=IF(ISERROR(VLOOKUP(B4,Sheet2!$A:$D,2,FALSE))=TRUE,"",VLOOKUP(B4,Sheet2!$A:$
D,2,
FALSE))

How can I modify this function to concatenate multiple entries on the
same date?

Thanks in advance,

Dave

Take a look here under Arbitrary Lookups:
http://www.cpearson.com/excel/lookups.htm

 

[DavidObeid]

Thanks Paul,

That site had some good info, but I don't think the suggestions ther
are applicable to my problem.

Regards,

Dav

 

[Alan Beban]

It isn't entirely obvious from the site, but the following, array
entered into a 5-column row, will return the 1st through 5th occurrences
of values corresponding to the value in cell B21:

=INDEX(B5:C19,SMALL(IF(B5:B19=B21,ROW(B5:B19)-ROW(B5)+1,ROW(B19)+1),{1,2,3,4,5}),2)

Alan Beban

 

[Dave Peterson]

I have a UDF in my personal.xla file.

You can read about it in this thread (along with some more options):
http://groups.google.com/[email protected]