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

B

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)
 
S

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
 
M

muddan madhu

try this ???

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top