Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Copy data on string name

    Hello Experts !

    I have a template which contains names which is static and two data sheets one is latest and other is previous . All three sheets having column B names there but random i need that code look to the template static names and and check in latest sheet if find the same name then copy data to template same for previous data sheet?

    Regards,
    Farrukh
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    In C8 (and fill down) use: =VLOOKUP(B8,latest!B2:C39,2,FALSE)

    In D8 (and fill down) use: =VLOOKUP(B8,latest!$B$2:$H$39,3,FALSE)

    Then, in E8, change the "3" above to a 4, etc., etc.

    Do something similar for the other lookup.

    Hope this helps and is what you were looking for.

    Kevin

Posting Permissions

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