The carcinoembryonic antigen (CEA) test measures the amount of this protein that may appear in the blood of some people who have certain kinds of cancers, especially cancer of the large intestine (colon and rectal cancer).
In this INDEX / MATCH example, the MATCH function will find the position of Jacket in column B, and the INDEX function will return the code from the same position in column A. Set up the worksheet as shown at right. Enter the following formula in cell B6: =INDEX($A$2:$A$4,MATCH(A6,$B$2:$B$4,0))
The difference is illustrated below. The other key difference is that INDEX MATCH formulas work as a right to left lookup, whereas VLOOKUP only works left to right. As you can see in the example below, I can use INDEX MATCH to lookup a value that is to the right of my return value using INDEX MATCH.When we combine both the INDEX formula and the MATCH formula, the number that the MATCH formula returns becomes the row number for your INDEX formula. =INDEX (array, MATCH formula). Below is an example of using the INDEX MATCH to return âProduct Typeâ for our lookup value.As you can see, it returns the same value we got from VLOOKUP.INDEX (array, row number). Below is an example of using INDEX to return the value âShirts,â assuming that you already know that the value is three cells down on your defined array. (you also have the option to specify column number, but that isnât relevant in a basic INDEX MATCH formula).