Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i want to type a value into a cell and have a function that returns the
header of the column that has a value that is closest to the value I typed in .. For example, you have a table and the first row is numbered 1 through 10 (column headers). The second row has values 5, 10, 15, etc in columns 1 through 10. I type in the value 12. I want the function to return "2" (because 10 is closest to 12 and it is in column 2). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
Complicated lookup function | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |