Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |