Selecting a particular column from a table and finding a figure equal or nearest to another figure

[baidya91]

I have a table of figures with several columns. I want to select a particular column and find a particular figure equal or nearest to another figure. Then I want to know the row number of the figure selected. The example is as follows: I want to select column 10 and find a figure equal or nearest to 35000, i.e, 35100 and therefore the row level number will be 4. Please help me out. Thanks in advance.

Level	1	2	3	4	5	6	7	8	9	10
1	17000	17600	18800	19700	21000	22700	24700	27000	28900	32100
2	17500	18100	19400	20300	21600	23400	25400	27800	29800	33100
3	18000	18600	20000	20900	22200	24100	26200	28600	30700	34100
4	18500	19200	20600	21500	22900	24800	27000	29500	31600	35100
5	19100	19800	21200	22100	23600	25500	27800	30400	32500	36200
6	19700	20400	21800	22800	24300	26300	28600	31300	33500	37300
7	20300	21000	22500	23500	25000	27100	29500	32200	34500	38400

 

[Fluff]

Duplicate Finding the row-level

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).