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! :-)
Bookmarks