Use of SUMPRODUCT or VLOOKUP??

[luissa01]

Hi to all,

Would like some help to fill a column (Approval) that is dependent to the conditions of two other columns (Vlaue & Quantity) and should also comply with a conditional Approval type which is included in another Sheet "Países". I have tried the SUMPRODUCT, then I tried VLOOKUP and finally I have tried a looooong string of IFs and ANDs and got all mixed up!

I attach the file for your perusal.

Many thanks.

[Richard Buttrey]

Hi,

In L3 and copied down

=IF(OR(AND(G3="UK",K3<VLOOKUP(G3,Países!$A$4:$E$8,4,FALSE)),AND(OR(G3="China",G3="USA"),C3<VLOOKUP(G3,Países!$A$4:$E$8,5,FALSE))),"Denied","Approved")

Regards

[luissa01]

Hi,

In L3 and copied down

=IF(OR(AND(G3="UK",K3<VLOOKUP(G3,Países!$A$4:$E$8,4,FALSE)),AND(OR(G3="China",G3="USA"),C3<VLOOKUP(G3,Países!$A$4:$E$8,5,FALSE))),"Denied","Approved")

Regards

Many thanks Richards, that did the trick!!!!