Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLOOKUP Function (Excel 2003)

    I need to use the VLOOKUP function to display the description and unit price of a product when the user enters the corresponding item number for the product. I have 2 worksheets. on the first is my invoice. it has a column for Item number, Description and unit price. On the second is my product table. Has a column for the Item number, Description of each product and the Unit Price for each. PLease Help!

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

    Re: VLOOKUP Function (Excel 2003)

    Welcome to Woody's Lounge!

    See if the attached workbook does what you want. I have defined a named range Products and used that in the VLOOKUP formulas.

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP Function (Excel 2003)

    HansV,

    Thanks for your help. Unfortunately, i have no idea what I am doing. I attached the document I am working with to give you and example of what i am doing.

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

    Re: VLOOKUP Function (Excel 2003)

    The VLOOKUP function has four arguments of which the first three are obligatory
    1) The search value
    2) The table to look in
    3) The column number that contains the value to return.
    4) A TRUE/FALSE value: if FALSE, the search must be exact, if TRUE, VLOOKUP will stop searching at the first value that is greater than or equal to the search value.

    Take cell B15 in the Invoice sheet.
    - The search value is in A15.
    - The table to look in is Products!A4:C10.
    - The description is in column 2.
    - You want an exact search, so the 4th argument must be FALSE.

    The formula in B15 becomes

    =VLOOKUP(A15,Products!$A$4:$C$10,2,FALSE)

    To avoid an error if A15 hasn't been filled in yet, you can expand this formula a bit by testing first if A15 is blank:

    =IF(ISBLANK(A15),"",VLOOKUP(A15,Products!$A$4:$C$1 0,2,FALSE))

    The formula to look up the unit price in D15 is similar, but the return value is in the 3rd column instead of in the 2nd column.
    The formula for the extended price in E15 is simple: =C15*D15. Again, to avoid errors if A15 is blank, you can expand it:

    =IF(ISBLANK(A15),"",C15*D15)

  5. #5
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP Function (Excel 2003)

    wow. let me try that. thanks Hans

Posting Permissions

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