A | B | C | D | |
1 | Country | Product Size | Type of product | Quantity |
2 | USA | 100g | Regular | 3000 |
3 | Brazil | 100g | Regular | 5000 |
4 | USA | 100g | Regular | 4000 |
5 | | | | |
6 | | | | |
A | B | |
USA, 100g, Regular | ||
1 | =IF(AND(A2="USA",B2="100g", C2="Regular"),D2,IF(AND(A3="USA",B3="100g", C3="Regular"),D3,if(…)) à in this case it will display 3000 | I need a formula to find depending on the country, product size and type of product, after the value found in A1, in this example I need to display 4000 and not 3000 |
If im not clear enough please let me know.
The second table shows all the quantites of USA , 100g , regular, quantities.. so i want to show all the quantities related to these criterias. Thank you !
Last edited by a moderator: