Working one step at a time lets leave the column hardcoded as 2 and make the row number dynamic. Heres the revised formula with the MATCH function nested inside INDEX in place of 5. INDEX Sheet2BBMATCH A1914Sheet2BB0 If your data in Sheet2 is in column-A then your formula should be.
Explaining formula in cell C14.
Here is what the worksheet would look like TOP and what the expect result would be BOTTOM. For instance here is a graph showing how much a specific fruit costs based on the amount purchased or type. In the MATCH function you have to select one column or One row from the same range that you have defined under INDEX. The MATCH function returns the relative position of a value in an array or cell reference this example has two values that makes it return an array of 2 values.