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

You have 2 conditions for price - product and customer's type.

Use SUMIFS instead of VLOOKUP, like

Please post your sheet on the forum. External links are potentially unsafe

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post