Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2004
    Location
    Indianapolis, Indiana, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet (Excel 2000)

    Help~

    I have created a form that we are going to use as an Inspection Sheet. I need to be able to type in the part # and have the other columns where the thickness, length, and width dimensions automatically get filled in from a database that is on Worksheet #2. Can anybody help me??????
    Attached Files Attached Files

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet (Excel 2000)

    You should use the VLOOKUP worksheetfunction:
    e.g. if you fill in the part number in A7, then the following formula in C7
    =VLOOKUP(A7,Sheet2!B5:N15,2,FALSE)
    should give you the target value from the database on Sheet2.
    etc.

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

    Re: Worksheet (Excel 2000)

    You need to use VLOOKUP. The attached workbook has the formula filled in for the thickness to show how it works. Use similar formulas for the other cells.
    Attached Files Attached Files
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Jul 2001
    Location
    Scottsdale, Arizona, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet (Excel 2000)

    It looks like you need to use the 'VLOOKUP' function (Vertical Lookup). Look it up in Excel help:

    "Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. "

    I put an example of this function in the first row of your spreadsheet.

    I hope this helps-
    <img src=/S/king.gif border=0 alt=king width=21 height=22> Eric
    Attached Files Attached Files

  5. #5
    New Lounger
    Join Date
    May 2004
    Location
    Indianapolis, Indiana, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet (Excel 2000)

    Thanks, I'll try it.

Posting Permissions

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