![]() See tutorial on how to insert drop down menus here We then create drop down menus for our Sales Rep column and another one for our Units/Sales/Avg Sale column names See tutorial on how to convert to an Excel Table here Let’s go…įirst we need to convert our data into an Excel Table by pressing Ctrl+T ![]() This is a little advanced so you will need to drop what you are doing and really focus. ![]() We can use the INDEX-MATCH formula and combine it with Data Validation drop down menus to return a value based on 2 criteria. =INDEX( return the value/text, MATCH(from the row position of this value/text)) =INDEX( array, MATCH(lookup_value, lookup_array, ) Searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function)
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |