Here, the lookup_value is B8, and the array range is A1: C6. Thus, the price of the product sold by Doug is 60.Įxplanation of the formula: “ =LOOKUP( B8, A1:C6)” Step 3: Press “ Enter” to see the result. Step 2: Enter the formula “ =LOOKUP( B8, Al:C6)”, as shown below. In this example, we will use the array form.įor instance, you have the below data and want to know the price of the product sold by Doug. In all the above examples, we have used the vector form of the LOOKUP function. How do you search value using the array form? Step 3: Press “Enter” to get the desired result. Step 2: Enter the formula “LOOKUP( B5, B1:F1, B3:F3)” as shown below. Now, you want to find the number of apples. In this example, you will learn to search for deals in a one-row range.Ĭonsider the below table of products and their quantity arranged in a row. In the above two examples, you have learned to use the vector form of the function to search for value in a single column. How to search for a value in a one-row range? Thus, the output of the given formula is 70. The look_up value is in A5 now, the function returns the value in the same row from the result_vector range (B2:B6), i.e., B5. Here the lookup_value is A04 the lookup_vector is A2:A6, and the result_vector is C2:C6. The lookup_value, A04, is first searched in the range of lookup_vector (A2 to A6). Hence, the price of ID A04 is 70.Įxplanation of the formula: “ =LOOKUP( B8, A2:A6, C2:C6)” Step 3: Press “ Enter” to get the result. Step 2: Enter the formula “ =LOOKUP( B8, A2:A6, C2:C6)” as shown below. To search for a price, follow the steps of the solution. The below data consist of ID, Items, and their price, and you want to find out the price for ID A04. Let’s take another example to understand the vector form of the LOOKUP function. In simple terms, the value of Cell B8 is present in A4, and the function returns the value from the same position in another column, B4. This LOOKUP function searches the lookup_value, Cell B8 (Kim), in the lookup_vector, A2:A6, and returns the value in the same row from the result_vector, B2:B6. Thus, Kim sold Clothes.Įxplanation of the formula: “ =Lookup( B8, A2:A6, B2:B6)” Step 2: Enter the formula “ =LOOKUP( B8, A2:A6, B2:B6)” as shown below. You want to find out the product sold by Kim. In this example, you will learn how to search for a specific value in one column range using the vector form of the lookup function.Ĭonsider the below table containing details of sellers and their products. How to search for a value in a one-column range? You can download this LOOKUP Function Excel Template here – LOOKUP Function Excel Template Example #1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |