Search code examples
excelexcel-2013

Excel: What's the best way to output a number based on it's place in a range?

A1 will fall within a range in my sample data. What's the best way to search a range for A1 to output the D cell number into E1 please?

Example 1:

enter image description here

Example 2:

enter image description here

Solution

  • Use the following INDEX/MATCH:

    =INDEX(D:D,MATCH(A2,C:C,-1))

    enter image description here