A vlookup with one condition is simple enough. How would I do a vlookup to get me the cost of smth in the province of Ontario that is 10 KM away?
<tbody>
Province
Distance
Price
ON
5KM
$5
ON
10KM
$10
Quebec
5KM
$15
Quebec
10KM
$20...
<tbody>
Province
Postal Code
Shipping Net
Ontario
M4M 1L4
$3
Ontario
M4M 1X5
-1
Ontario
M4M 3Z7
-50
BC
Y3L 1Z4
-30
BC
Y3L 1X5
-300
BC
Y3L 1M9
-700
</tbody>
I have about 200K rows of transactions, to a whole set of postal codes. I'm...
Hello everyone!
I have an excel file where some data is provided by other teams (call this the "Source"). I need to take this information and copy it to specific columns in another excel workbook (not worksheet) (call this the Destination) where the Province matches in both worksheets. I am...
Hi,
I face an issue with imported text over a few hundreds lines:
One cell (A1) is like this
Belgium BE » Flanders VLG » Antwerp Province VAN » Arrondissement of Antwerp 11 » Antwerpen 11002
and I wish to have Antwerpen (11002), Arrondissement of Antwerp (11), Antwerp Province (VAN), Flanders...
Would appreciate some help please.
I have quite a large dataset that gets updated on a monthly basis (100,000 rows +). There are 4 unique provinces each 10 unique counties in each province. The users that enter data into the form - using drop down boxes - that generates these fields (among...
Pls find the attached file.
https://drive.google.com/file/d/1gEUX8QJ8rugKYACuYRISCAI3MmWlOM5i/view?usp=sharing
What im looking to get is province name in coloumn B of "Address" sheet. Province names are listed in the sheet "Province"
Any help is greatly appreciated. Thanks for your time.
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.