# Vlookup

#### ARatn

##### New Member
 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.

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### Domenic

##### MrExcel MVP
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

##### New Member
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

##### MrExcel MVP
You're very welcome!

Replies
4
Views
415
Replies
21
Views
660
Replies
1
Views
209
Replies
1
Views
274
Replies
12
Views
905

1,191,036
Messages
5,984,273
Members
439,881
Latest member
Amitoj95

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back