View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Latika Latika is offline
external usenet poster
 
Posts: 6
Default Complicated Lookup Function

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).