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:

Example 2:

Solution

Use the following INDEX/MATCH:

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

How to make picture %60 transparency in vba?
Draw vertical line in scatter plot?
Special character check mark
How to change Font Color of Dates without changing color of other text or background using VBA for Excel
Update cell value based on another cell VBA
Use Console as debug window in VBA
Calculate median using vba
How can I join cells with a vertical line?
How to change font color for specific line (row) of Textbox
How do i use Excel Random list generation without duplicate
excel countif entire row in a table
Simplifying If Statements Into Loop
What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
How to find and replace with regex in excel
How to format graph to show dates from one or more sheets on the horizontal axis?
How to embed a SVG into a Cell using Aspose.Cells
Run-Time Error 91 (object variable or with block variable not set) on VBA Email code "mailItem.Display" after IF statements
loop through excel raw data file and input them to other excel formula sheet and perform iteration calculation
Deleting duplicate header rows
mixed date converted from default mm/dd/yy in excel to dd/mm/yy
Overwrite Excel 2016 worksheet data with data from CSV file
Laravel validator and excel files error
Need help aligning a table to a column based on similar values in one table field
Index rows and columns unexpected results
Ascii Art using VBA
How to obtain the full-path names of files read with WorkbookConnections
How can export all part of columns to pdf file with VBA code?
Difficult to run
Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
Export Charts from Excel as images using Python