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