VLOOKUP combining info from several cells in several rows to one c

[Black Ram]

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)

 

[ShaneDevenshire]

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

 

[muddan madhu]

try this ???

=INDEX(Sheet1!C1:C4&" "&Sheet1!D14&" "&Sheet1!E1:E4,MATCH(Sheet1!
C12,Sheet1!B1:B4,0),0)

 

[Black Ram]

muddan madhu,
This is a great start. I tried the formula but it only shows data from one
row in each column. I need it to show the data from all rows with the same
date as a list on the calendar.