4,117 views
In this video, we will talk about explaining the Choose search function, which is used to choose a value from a list of values based on the given index number. It is an important function that saves us from using other large functions such as the VLOOKUP function and the IF function, as we talked about the following topics: 00:00 Introduction 00:17 Example 1. Get the item name through its order number. 03:37 Example 1. Get the item name, price and specifications through its order number. 03:37 Example 2: Solve the problem of pulling the equation down, and how to hide errors. 08:11 Example 3: Merge the choose equation with the sum equation, and get the total revenues during a specific month. Work file: https://www.mediafire.com/file/xd5ld0... Absolute and relative references in Excel: • Excel tricks and secrets Fixing cells inside...