Hey All,

I've created an price proposal template where I want to select a customer type, fill in product ID and let the sheet look up the rest in a second TAB. The only problem is: I can't seem to get the correct price tab working. Can someone please help me?

here's the excel example. the problem is in de K. Now using this formula:

=IF(B19="";"";VLOOKUP(B19;Disposables!B4:Q7;5;0))

the '5' should become 11, 13 or 15 corresponding the customer type chosen in D4

http://www.filedropper.com/voorbeeldpriceproposal