+ Reply to Thread
Results 1 to 2 of 2

Can't get the HLOOKUP function to work properly

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    3

    Can't get the HLOOKUP function to work properly

    Here is my Excel file:
    Lijsten_VanCamp_Dennis.xlsx



    I have problems with the function HLOOKUP in sheet 2 and 3.

    In column C worksheet #2 ("Oefening op zoeken in lijsten"), I need to add the description found in sheet 3, B2:E2 by using the function HLOOKUP.
    In column E worksheet #2, I need to add the selling price (selling price = "inkoopprijs" (buying price) * "factor")

    Here some translations to avoid confusion
    Sheet 2
    C3 = "Description"
    E3 = "Selling price"

    Sheet 3:
    A1 = "Category number"
    A2 = "Category description"
    A3 = "Factor"

    I manually adjusted the code a bit in column C, but that is not the correct way to do it.

    I been trying all sorts of thing but I just don't get it to work. It's not a long code, but I've been looking too long at it that I am desperate for help. Thanks! :-)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094

    Re: Can't get the HLOOKUP function to work properly

    Hi,

    In C4 =HLOOKUP(B4,informatie,2,FALSE) - Copy down
    In E4 =HLOOKUP(B4,informatie,3,FALSE)*D4 - Copy down

    HTH
    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1