Vlookup

[ARatn]

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.

 

[Domenic]

Try...

Sheet1!C2, copied down:

=IF(B2<40,INDEX(Sheet2!$B$2:$D$7,MATCH(A2,Sheet2!$A$2:$A$7,0),MATCH(D2,Sheet2!$B$1:$D$1,0)),0)

Hope this helps!

 

[ARatn]

Thank you very mch

Amin

Try...

Sheet1!C2, copied down:

=IF(B2<40,INDEX(Sheet2!$B$2:$D$7,MATCH(A2,Sheet2!$A$2:$A$7,0),MATCH(D2,Sheet2!$B$1:$D$1,0)),0)

Hope this helps!

 

[Domenic]

You're very welcome!