Skip to main content

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

Labels:

Comments

Post a Comment

Popular posts from this blog

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 Produ...
29 comments
Read more

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 Discou...
21 comments
Read more
Excel Some Useful Shortcuts Excel Some Useful Shortcuts Shortcut key Action Menu equivalent comments Alt or F10 Menu Go to Menu bar Alt+’ Format Style dialog box Format the Style Alt+= AutoSum Sum Formaula Showing in Cell Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List Alt+F1 Insert Chart Insert the Chart Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Alt+F2 Save As Save File to Save As Alt+F4 Exit File Exit Alt+F8 Macro dialog box Macro dialog box Tools Alt+Shift+F1 New worksheet Insert New Worksheet Alt+Shift+F2 Save Save the File Ctrl + Shift + L Filter Filter the Row Ctrl W Close Close the Open File Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection Ctrl+! Format cells dialog box Font Tab Open in F...
18 comments
Read more