Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
How to replace a function with its resulting reference in a formula? | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |