LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting info from one col. and combining it with a simple formu Eqa Excel Discussion (Misc queries) 3 January 7th 08 02:32 AM
Combining Cell Info ohsix New Users to Excel 6 May 29th 07 04:18 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM
Combining spread sheet info Lewis Shanks Setting up and Configuration of Excel 0 January 7th 06 12:57 AM
combining 3 columns of same info for a pivot table Julie Excel Worksheet Functions 0 December 15th 04 03:12 PM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"