hello all
having some trouble and not having much luck with multiple criterias
basically i would like the following:
in the summary sheet (column P) > i have highlighted in red my formula
=INDEX('Ship-to Price (Datawork)'!$A$2:$W$521,MATCH(Summary!$C8,'Ship-to Price (Datawork)'!$U$2:$U$521,0),11)
its giving me an answer but i need to also do it by "minimum rate" which is column Q from the "ship-to-date (datawork)"
basically, i want the same formula but i want to filter by column Q to show a value if it is minimum rate.
can someone pls help?
Bookmarks