Google Sheets Accounting Lookup formula help

jcoeng

New Member
Joined
May 11, 2011
Messages
15
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hello, I have an accounting record built in GSheets designed to enter transactions and based on a couple of selections properly allocate the transaction to individual accounts or all accounts.

I'd like to make some changes to enable more "automation" instead of hard coding ranges in the following ways. The goal is to make it easier to modify when adding additional individual accounts, groups of users etc. A few specific questions I have are listed in the sheet at the bottom but summarized here.
  • How can I modify a formula to match a name in a list using only a partial match. Example finding "Jason", when "Jason C" is listed.
  • I'm using index match to pull data from a table, I Need to modify the formula to use the index range from the table based on matching the headings between the two tabs.
  • How can I modify a formula to apply only in a column where a heading is found in a list that matches a drop down selection.
More specifics in the linked sheet with cell references.

Thank you!
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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