Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    May 2007
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Look up moving data to cell with look up. (2003)

    Hi I have attached a document with blank cells which is called discharge date. I have a set of data that needs to be moved into the discharge cells, matched by the Ni number.

    I have listed instructions on the xls.

    If you could help that would be great.

    Thank you so much
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Look up moving data to cell with look up. (2003)

    Welcome to Woody's Lounge!

    Enter this formula in F2:
    <code>
    =IF(ISNA(VLOOKUP(D2,$H$2:$I$231,2,FALSE)),"",VLOOK UP(D2,$H$2:$I$231,2,FALSE))
    </code>
    and fill down as far as needed (for example by double clicking the fill handle in the lower right corner of F2).

    The essential part of the formula is
    <code>
    VLOOKUP(D2,$H$2:$I$231,2,FALSE))
    </code>
    This looks up the value of D2 in column H, and returns the corresponding value from column I. The rest of the formula is intended to suppress the #N/A value if the Ni number is not found.

  3. #3
    New Lounger
    Join Date
    May 2007
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Look up moving data to cell with look up. (2003)

    Hi hans I still need help please. All the discharge dates on the right hand side (I Column) of the spreadsheet need to be put into the empty discharge date column (F) on the left of the spared sheet. The discharge date is matched with the Ni number on the right (H column) and the Ni number on the left (D column). I hope you understand, and thanks for your help.

  4. #4
    New Lounger
    Join Date
    May 2007
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Look up moving data to cell with look up. (2003)

    I have attached again the attachment with updated instructions, if you could have a look at the attachment and help/advice me that would be fantastic.
    Attached Files Attached Files

  5. #5
    New Lounger
    Join Date
    May 2007
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Look up moving data to cell with look up. (2003)

    I did try that formula, but didn't understand the out come, my previous post I have again attached the excel spreadsheet with updated instructions. I hope you can help, and again I thank you for your help/advice.

    Thanks
    Attached Files Attached Files

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Look up moving data to cell with look up. (2003)

    The attached file uses a slightly different method from Hans' but both should produce the same outcome. Note that I formatted the cells in F as dates, otherwise you will see numbers like 39156 instead of 15/3/2007.
    HTH
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    New Lounger
    Join Date
    May 2007
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Look up moving data to cell with look up. (2003)

    Thank you for your help , problem solved. Do I delete this post if problem is solved or do do I leave it on here.


    Thanks again

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Look up moving data to cell with look up. (2003)

    Rory has already pointed out the most important factor: you must format column D with a date format, otherwise you'll see numbers such as 39152. When I created the formulas, Excel applied a date format automatically, apparenly this didn't happen when you tried it.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Look up moving data to cell with look up. (2003)

    We leave threads in place when they have been solved - they might help someone else in the future. Many Loungers use the Search feature (in the "menu bar" at the top of the Lounge window) to see if a question has been asked before.

Posting Permissions

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