Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all I need to do the following with the attached spreadsheet

    • Sheet 1 is a simple spreadsheet list of external training in date order
    • Sheet 2 is a simple calendar
    • I want to transfer the data from sheet 1 into the sheet 2 calendar using a Vlookup on Date
    • The data I want transferred is training type and service (obviously it will go into the relevant date on the calendar)


    I haven't done Vlookup for a very long time if you can help it will be much appreciated.



    Many thanks
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Since there can be more than one course on the same day, you can't just use VLOOKUP. You could use Sdckapr's VLookupAll function from Post 395235.

    See the attached version.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •