Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting info from one col. and combining it with a simple formu | Excel Discussion (Misc queries) | |||
Combining Cell Info | New Users to Excel | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Combining spread sheet info | Setting up and Configuration of Excel | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |