Hi everyone,

I need a formula that searches one column for the name of a customer, a 2nd column for the delivery point, then a row for the rate that the delivery was done at, and finally equal the cell that matches all of these. I tried addapting a formula that I used to look up stock that we store, but it didn't have to look in rows and columns and I'm wondering if that's why this isn't working. Here's what I've got so far;

=IFERROR(INDEX(Customers!H:K,MATCH(1,(Customers!D:D=$J4)*(Customers!F:F=$O4)*(Customers!1:1=$Z4),0)),0)

This produces a message telling me that 'Excel ran out of resources while attempting to calculate one of more formulas. As a result, these formulas cannot be evaluated.'

I'm hoping someone can point out that I've just made a daft mistake as I really need to get this to work! Please let me know if you need any more info.

Many thanks in advance,

Ben