Hello!!! I am having difficultly getting a formula to work.
=INDEX(OLPPricingTable,MATCH(PricingType,OLPPricingTablePricingTypes,0),MATCH(D200,OLPPricingTableChannels,0),MATCH(OLPNPRTotal,OLPPricingTableNPRLookup,1))
I need to match a column exactly, a row exactly and a column greater than/less than.
I’ve checked syntax. I’ve checked table sorting. I do use CSE to close.
Any ideas?
Thanks a million!!!!!
=INDEX(OLPPricingTable,MATCH(PricingType,OLPPricingTablePricingTypes,0),MATCH(D200,OLPPricingTableChannels,0),MATCH(OLPNPRTotal,OLPPricingTableNPRLookup,1))
I need to match a column exactly, a row exactly and a column greater than/less than.
I’ve checked syntax. I’ve checked table sorting. I do use CSE to close.
Any ideas?
Thanks a million!!!!!