Look for value match and if not found, find nearest match using variables

crysperez

New Member
Joined
Aug 21, 2014
Messages
3
I hope it's okay that I cross posted my inquiry since I have not found a solution.

Hello and thank you for any help you may be able to provide!

I'm new to VBA and I've tried several different ways to accomplish this using EXCEL functions but I would like to simplify my workbook by using VBA.

I have a workbook with 3 varying data sources and I need to match values to determine volumes and then calculate billing details. The data sources are on separate sheets but simplify things, we can have the data sources all on one sheet. I need to sum volumes by matching up the account number in the order of priority as listed below:

1) Account Number_Meter Number_Location Number (If found use this to search sum volumes in column M)
2) Account Number_Any combination of Meter Number or Location Number (If found use this to sum for volumes in column M)
3) If none of the variables (Account Number, Meter Number, Location Number) match then just use Account Number to sum volume

Thank you very much to anyone that can help me solve this.

Cross posted here
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,903
Messages
6,175,279
Members
452,630
Latest member
OdubiYouth

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.
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.
Go back
Back
Top