Thread: VLOOKUP help
View Single Post
 
Old 03-16-2018, 07:15 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
You have 2 conditions for price - product and customer's type.

Use SUMIFS instead of VLOOKUP, like
Code:
=SUMIFS(Disposables!$F$4:$F$7,Disposables!$B$4:$B$7,$B19, Disposables!$?$4:$?$7,$B$4)
Reply With Quote