I am trying to do a find and replace type formula where the worksheet looks
at a cell with a number (or in this instance date) within a worksheet, then
searches a seperate worksheet to find the date closest from a list of 24
variables and adds that value to the cell

Example: I have a spreadhseet that calculates a simple timeline (1 variable
+ another). After this I want the end variable to be the reference point for
a meeting. The meetings are set times within the calendar year (will not move
with variable) and therefore will need to reference this list and find the
closest meeting to the end variable .
Can anyone help