Index match excel11/28/2023 Looking up a value with two or more row criteria Now let’s say we need to lookup Guy’s sales for the West. Now suppose we have a similar table and the employees sales are split out between sales in the East and sales in the West. Looking up a value with a row criteria and a column criteria Or, we could get fancy and use an index match combination using this formula. Now, if we want to get Allison’s sales, we could use a VLOOKUP formula using this formula. Let’s say we have a table with employees and their total sales and we want a formula to return the total sales based on the employee. Get The Completed Workbook Looking up a value based on one criteria
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |