In this article we will learn about how we can recover sale price based on item and color criteria in Microsoft Excel 2010
To retrieve sale price based on item and color criteria, we will use a combination of “INDEX” & “MATCH” functions to get the output.
“INDEX”: Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
“MATCH” function searches for a specified item in a selected range of cells, and then returns the relative position of that item in the range.
Let us take an example:-
We have list of items in column A, color of the item in column B and price of the item in column C.We need a formula to find the matching price for each pair of item and color values entered in A9:B12.
This is the way we can regain the sale price based on item and color criteria in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.