INDEX With MATCH Function

Combining the INDEX Function Formula with MATCH Function Formula In Excel

INDEX Function Formula With MATCH Function Formula

need to specify more complex conditions when writing your formula in Excel. You can combine the INDEX function Formula with MATCH functions Formula

This Function Formula is Most Useful to Reverse LOOKUP Find, Look like Similar to VLOOKUP Function Formula, VLOOKUP Find Right Side Column Value and INDEX With MATCH Function Formula Find Left Side Column Value

For Example :

A B C D
Qty Product Name Product Name Qty (Result)
5854   Saree Tunic 552
8582   Dress Material Shirt   2524
2854   Tops     Saree 5854
2524   Shirt     Dress Material 8582
552   Tunic Tops 2854

INDEX With VLOOKUP Function Formula is

=INDEX(A:A,(MATCH(C:C,B:B,0)))

=INDEX(A:A,(MATCH("Shirt",B:B,0))) For Use Only one Individual Data Find

Comments

Discount Formula in Excel

Discount Formula in Excel To Discount Formula an original price minus 5 is the same as Calculate to 95 of that value so if you have the Product Price (4585) in A2 use the Discount Formula Here the Below Example for Discount Formulas : - 5% Discount formula is =A2*0.95 10% Discount formula is =A2*0.90 15% Discount formula is =A2*0.85 20% Discount formula is =A2*0.80 25% Discount formula is =A2*0.75 30% Discount formula is =A2*0.70 40% Discount formula is =A2*0.60 50% Discount formula is =A2*0.50 Another Way to Calculate Discount Formula in Excel How to Find Discounted Amount in Excel Column A is Product Price, Column B is Discount Percentage, Column C is Discounted Amount and Column D is After Discount Amount Discounted Amount Formula is =A2*5% After Discount Amount Formula is =A2-C2 Another Easiest Way to Calculate Discount F ormula Col umn A is Product Pr ice, Col umn B is Discount Percentage % and C is After Discount

IFERROR With VLOOKUP And LEN AND LENB FUNCTION

Combining the IFERROR Function Formula with Logical VLOOKUP Functions Formula IFERROR Function With VLOOKUP Function Formula Description : - Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR Function With VLOOKUP function to trap and handle errors in a formula Below Following Values if Error : - #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! For Example A B C D Description Value Description Value Lookup Product #N/A Product 0 Product Details #VALUE! Sale5 0 Item #REF! Sale 0 Sale #N/A Item 0 Sales #DIV/0! Name 0 Name #NAME? Num 0 Num #NUM!

VLOOKUP Function

How to Use VLOOKUP Function Formula in Excel VLOOKUP Function Formula is one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up an Product Quantity, Product Details or Product SKU, find any phone number by looking up Their last name (just like a telephone book Directory). The secret to VLOOKUP Function Formula is to organize your data so that the value you look up (Product Quantity) is to the left of the return value you want to find (Product Quantity's). VLOOKUP Function Formula Syntax : - =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) For Example : - Argument name Description lookup_value (required) Which value you want to look up. Which value you want to look up must be in the first column of the range of cells you specify in table-array (Lookup Value is C) For example, if table-array spans cells A:B, then your lookup_value

Basic Excel Simple formulas

Search This Blog