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))
=INDEX(data!B4:B52,MATCH(input!$B$3,data!$A4:$A52)) That formula matches in col A and returns a value from col B as does your VLOOKUP, but when you copy across that changes. Note that I used MATCH with no third argument to be consistent with your VLOOKUP with no fourth argument. Because the same MATCH function is repeated across the whole row then for more efficiency you could put that function alone in one cell then refer to that same cell across the row.