Attached the Google Drive link and we have to refer to scenario 2 sheet of the spreadsheet.
Here some value is given in rows and we need to find the closest value from this range of cells in a row. Input is also given in the sheet and it is very much related to Scenario 1 sheet given in the link where given values are arranged in a column.
Scenario 2 sheet contains the values arranged in rows instead of columns. So we need to find the closest value for the given input and also column number of that row which matches with the input value.