SHEET 1 | |||
Province | Sales | Transport | Division |
NS | 88,84$ | WEB | |
BC | 79,55$ | WEC | |
QC | 238,68$ | WEC | |
ON | 71,97$ | WEB | |
AB | 19,99$ | AMA | |
ON | 7 196,00$ | WEC | |
NS | 121,28$ | WEB | |
QC | 110,45$ | WEB |
SHEET 2 | |||
Province | AMA | WEB | WEC |
AB | 9,95 | 9,95 | 14,95 |
BC | 9,95 | 9,95 | 14,95 |
MB | 9,95 | 9,95 | 14,95 |
NB | 9,95 | 9,95 | 14,95 |
NL | 30 | 30 | 30 |
NS | 9,95 | 9,95 | 14,95 |
===========================
Hi, If total sales in sheet 1 (col 2) is less than $40 than it should pick the transport cost from sheet 2 with matching province and division from corresponding province and web on sheet 2 from one of three columns (AMA,WEB,WEC) on sheet 2.
Thank you for help on Sunday evening.