hi ,
could you please help me to find a formula for the below
this is my data
a b c d e f g h
1 2 3 4 5 6 7 8 9
2 11 13 15 17 19 21 23 25
3 28 31 34 37 40 43 46 49
4 53 57 61 65 69 73 77 81
5 86 91 96 101 106 111 116 121
6 127 133 139 145 151 157 163 169
And i want formula if a value is there in the table then return the column and the row
if the value is not there find the nearest value to it and return the column and row.
Example 1
Column Row
cell input 31 Result 31 b 3
Example 2
Column Row
cell input 100 Result 101 d 5
note 31 is there in the table
100 is not in the table.
thanks in advance.
Bookmarks