reference and replace data from one sheet to another
 

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

reference and replace data from one sheet to another
 

I am not sure I fully understand your message. However, finding the
value, within a list, that is closest to a given value is done with the
following *array* formula:

=INDEX(B1:B24,MATCH(MIN(ABS(A1:A24-C8)),ABS(A1:A24-C8),0))

As an array formula it should be committed with key combo
Ctrl+Shift+Enter

HTH
Kostis Vezerides

christoff13 wrote:
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