![]() ![]() Similarly, we can find out the quantities of other products like Orange. Press Enter to see the quantity of apples. How do we find the number of apples from this table? We can write this formula for this: Here we have a data table showing a product, price per unit and quantity. For writing a correct formula, just follow the syntax that is prompted when you start writing the formula. Here the lookup value was ID A04 the lookup_vector was A2: A6, and the result_vector was C2: C6. For this, we will write the formula as below: Suppose we want to find out the price for ID A04. We have s sample data showing ID, Items, and their Price. We wanted to find the product sold by Kim, so first, the function will search Kim in the A2:A6 range and then will return the value in the same position from B2:B6. It is the column from where the function will return the value. We will search for the lookup value in this column.ī2:B6 is the result_vector. Here B8 (Kim) is the lookup value as we want to know the product sold by her.Ī2:A6 is the lookup_vector. You will get to know how to write the lookup formula to find the needed values for various criteria. We will now look at how to use the Lookup function with the help of various examples. This function is used for finding prices of products from a data table, transactions from previous months/years, finding marks of students. The function can return string, numeric, name depending upon the data type. The Lookup function searches the lookup value in the Lookup vector and returns the value in the same position from the result vector. Array: It is the range of cells containing multiple rows and columns where you want to search the lookup value.Lookup _value: To search for a value in an array.Result Vector: It is a single row or column having data and of the same size as the lookup vector. Lookup Vector: It is a single row or column containing data sorted in ascending order.It can be a text, number, reference, logical value or a name. Lookup Value: It is the value that we want to search in a range or array.=LOOKUP(lookup-value, lookup-vector, result-vector) The LOOKUP function syntax has two types: It is present on all the versions of MS Excel. It can be found in Lookup & References under the Formula tab on the ribbon. So it can be used as a formula in a worksheet. This is a built-in worksheet function in Excel. In simple terms, this function searches the lookup value in a row or a column and gives a matching value in the same location from another cell or column. Excel functions, formula, charts, formatting creating excel dashboard & others
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |