Excel

Index & Match "To summarize, INDEX gets a value at a given location in a range of cells based on numeric position. When the range is one-dimensional, you only need to supply a row number. When the range is two-dimensional, you'll need to supply both the row and column numbers." "The MATCH function is designed for one purpose: find the position of an item in a range" Now, using index and match together, I can find the billing numbers for particular client and month. Feel free to utilize the data validated dropdown to change client and month to find its respective billing numbers.

 Website:  https://www.careerprinciples.com/resources/index-match-with-multiple-criteria Below, a user can test out the Xlookup & Concatenate criteria OR Index/Match & Concatenate criteria to find the commission for a particular row. In my example, I want a particular media type and different column criteria to find the commission.

Index/Match 2 Way Xlookup Website:  https://www.excel-easy.com/examples/two-way-lookup.html Match:  https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a Index:  https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd Below I use MATCH function to find the row and column number of a certain month or certain Pokemon Plushy. Then, I use the INDEX function to find the insertion of the row and number and that gives us the sales for that Pokémon Plushy for that month.