Formula to Perform a Rate Card Check (Non-Array Solution)

Morning all,

I've managed to construct an array formula that resolves this problem but ideally I would prefer a non-array solution. Basically I need to differentiate between rates that are either nil, i.e. the role undertaken is acceptable but there's no agreed rate and non matching, i.e. the supplier shouldn't be billing for that type of role. Example attached.

Thanks in advance,

Snook

Try:

Formula:

Please Login or Register  to view this content.