Results 1 to 7 of 7
  1. #1
    simon dennett
    Guest

    vlookup equations (excel 97)

    I am trying to link excel worksheets so that I have a master data document which will automatically update other worksheets. I believe that the solution is to use linked worksheets and then using the vlookup equation. I have an Excel 97 book which does not explain this process in the way that is simple and easy to understand. Can you help me?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup equations (excel 97)

    Whether the VLOOKUP function is what you need, depends on what you need to DO with the data from the master data workbook. If you could explain that a little we may be able to help.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: vlookup equations (excel 97)

    <A target="_blank" HREF=http://www.mrexcel.com/tip021.shtml>Here</A> is a tutorial on vlookup. As Jan said, we need more details to help you directly. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    simon dennett
    Guest

    Re: vlookup equations (excel 97)

    Jan

    I work for an Insurance company who uses various building contractors to carry out repairs to homes following storms, floods etc. I am trying to carry out a cost comparison between the contractors to establish the most cost effective method of repairing a properyty.

    Therefore, the main data file contains Insurance claims which have been priced using the various contractors. Because the contractor's methods of pricing varies, I have several worksheets which present the same data but in different formats thus allowing me to carry out different cost comparisons. Initially I cut and pasted the data into each of the worksheets but as the exercise increases in size this is no longer feasible.

    What I need is a document where I can enter the data into the main data worksheet and it automatically update the other worksheets.

    I hope that this is sufficient, if not please let me know

    Regards

    Simon

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup equations (excel 97)

    From this description, it does not sound like you need VLOOKUP. A simple reference to the cell on the other sheet should do what you want. For example, if you want the value in cell A1 on Sheet2 to appear in a cell, then the formula =Sheet2!A1 will do that.

    VLOOKUP is used when you have a table of values and you want to look up a value in one column and then use a value from a different column in the table. For example, you have a table with product codes in the first column and the price in the second column. VLOOKUP can be used to find a product code in the first column and insert the price from the second column. That does not sound like what you are doing.
    Legare Coleman

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: vlookup equations (excel 97)

    Simon, this may be more a matter of design than technique. Sounds like it may work better for you if you keep everything in one Workbook with multiple Sheets, where one "source" Sheet contains all your detail, then various "analysis" Sheets hold the various "takes" on the data, and if applicable, a "summary" sheet holds your conclusions on which contractor to use.

    You may want to limit the period for the WB to one month, one quarter or one years' data, depending on volume, and have one WB for each period. (We often use the term "worksheet" when we mean "workbook", so perhaps this is already how you operate.) It's easier to link sheets within a single large WB than across multiple WB's.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup equations (excel 97)

    Simon:
    It sounds like you want to set up a WS that you can use to analyse data from these contractors's bids that can be used over and over again. Focus on how you want the output to look and then assign names to the fields (rows and columns) that you want to import their data into. Then the next job will be to identify your field names with the names that each contractor uses so that you can set up lookup functions to import each variable from ech bidder. Actually, the best approach would be to design the form for each bidder to include in their bid. In that way you can minimize the amount of digging around you will have to do to get each contractor's numbers. I agree with the other commentors: namely, you do nothave enough to go on yet to build an application.
    Good luck
    Epic60sman <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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