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))
Microsoft Excel is one topic that I have taught extensively. The Match function is used to find the position of a value in a list of. So say you have a list of names, in the cells from A2 to A20, the Match function will search through the list and find which position a particular value is in.Say you have a list of fruits and you are looking for bananas, you could do this:icrosoft Excel is one topic that I have taught extensively. The Match function is used to find the position of a value in a list of. So say you have a list of names, in the cells from A2 to A20, the Match function will search through the list and find which position a particular value is in.