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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,223,885
Messages
6,175,184
Members
452,615
Latest member
bogeys2birdies

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