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

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)

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

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)

VLOOKUP combining info from several cells in several rows to onec
 

try this ???

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



On Oct 17, 8:16*pm, Black Ram <Black
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)

VLOOKUP combining info from several cells in several rows to o
 

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.

"muddan madhu" wrote:

try this ???

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



On Oct 17, 8:16 pm, Black Ram <Black
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)