Hi,

Each return value must be retrieved with a separate VLOOKUP

=VLOOKUP(39738,Sheet1!A2:F3,2,FALSE)&VLOOKUP(39738 ,Sheet1!A2:F3,3,FALSE)&VLOOKUP(39738,Sheet1!A2:F3, 4,FALSE) and so on.


In this case it might be easier to enter the date in another cell, say J1 as
a date and then use

=VLOOKUP(J1,Sheet1!A2:F3,2,FALSE)& and so on.

If this helps please click Yes

--
Thanks,
Shane Devenshire


"Black Ram" wrote:

I am trying to transfer multiple sets of data from columns C, D & E on sheet
1 by date to a list in a single cell on a calendar by date and have been
unsuccessful figuring out the formula. Does anyone have any ideas as to
solving this issue?

Example:
Sheet1: Log Worksheet
A B C D
E F
1 - 1st Follow-up 2nd Follow-up Company Contact PH# Date
2 - 10/17/08 10/31/08 Johnson Paul 555-5555
10/10/08
3 - 10/17/08 10/31/08 Jackson Jeff 555-6666
10/10/08

Sheet2: Calendar (Weekly)
A B
1 - October 13-
2 - October 17
3 - 10/13/08 10/16/08
4 - Formula for data Formula for data
5 - 10/14/08 10/17/08
6 - Formula for data Formula for data
7 - 10/15/08 NOTES
8 - Formula for data Formula for data

My Formula: =VLOOKUP(39738,Sheet1!A2:F3,3&","&4&","&5,FALSE)