Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: I need help...................

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm pretty to Excel. I have two workbooks....one has Admitting data in it and the other is discharge data.

    I want to be able to type in the information info in to the admit sheet (patient number, name, etc.)

    Then, when I open the Discharge sheet and input the patient name I would like to have it pull the data over from the Admitting sheet, so I don't have to input duplicate information.

    Can someone please help me with this?

  2. #2
    Guest

    Default

    Hi WildDaisy

    To get you started, try the VLOOKUP formula
    Create 2 workbooks. Name one ADMIT and the other DISCHARGE
    Put these details in the first 4 columns of ADMIT in Sheet1
    A B C D
    Patient No Name Address Age
    1 Jim road 20
    2 Fred street 30
    3 Pete lane 40
    4 Meg avenue 50

    Put these details in the first 4 columns of DISCHARGE in Sheet1
    A B C D
    Patient No Name Address Age
    1
    2
    3
    4

    In Sheet1 of DISCHARGE, select cell B2 and carry out this procedure
    type =VLOOKUP(
    Select cell A2 notice in the command line that this has added A2 to your formula
    Press F4 on your keyboard 3 times till the A2 in your formula becomes $A2
    (the $ before the column A keeps your formula fixed to that column when you scroll it )
    type a comma
    Select ADMIT, Sheet1 and the whole range from A2 to D5
    ( notice in the command line this has added your array
    as an absolute reference - ie both row and column are preceded by $)
    type a comma
    type: 2 this designates that you want data returned from column 2 or your array
    type a comma
    type: False this allows a search of the patient number even if they are not in sequence and returns error is match not found.
    type: )
    Immediately press enter.
    You now have the following formula =VLOOKUP($A2,[Admit.xls]Sheet1!$A$2:$D$5,2) in cell B2
    Now Select B2
    Put your cursor over the bottom right corner of this cell till the pointer becomes a black cross
    Hold down left mouse and drag right to cell D2
    Select cell C2 and change the last 2 in the formula to 3 (to get data from column 3). PRESS ENTER
    Select cell D2 and change the last 2 in the formula to 4 (to get data from column 4) PRESS ENTER
    Select range B2:D2
    Put your cursor over the bottom right corner of this range till the pointer becomes a black cross
    Hold down left mouse and drag down to cell D5

    By using the patient number as a reference you have now obtained data from the ADMIT sheet.

    Read the Help file on VLOOKUP and you will soon be an expert.

    Good luck
    Derek

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wilddaisy
    That's me (didn't mean to post as anonymous
    Derek

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you so much! That worked perfectly.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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