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))
You have two or more lists in Excel and you want to find out whether a value in one list exists in another. The MATCH function is what you're in need of. The MATCH function accepts 3 parameters: (1) lookup_value; this is the value you want to find.(2) lookup_array; this is the list that you want to search through.(3) match_type; this is optional and specifies if you want an exact match or a less/greater than match.ou have two or more lists in Excel and you want to find out whether a value in one list exists in another. The MATCH function is what you're in need of. The MATCH function accepts 3 parameters: (1) lookup_value; this is the value you want to find.