Formula to return a cell number, not cell value

I'm new at understanding Excel functions and formulas, and have looked around for an answer to this question, including reading through many of Excel's functions such as ISBLANK or VLOOKUP. Apparently I don't know what I don't know when it comes to the syntax for the particular problem I'm facing:

I have a spreadsheet that has a primary column with a number of major points (in this case designated by 1,2,3…200+) interspersed with a series of minor points (1.1, 1.2, 1.3,etc). The variability of the minor points is unknown, as the minor points could be as high as 99 but as low as 1 (e.g., 1.1 to 1.99 or anywhere in between).

I can't figure out how to draft a formula report back at which cell the next major point occurs (e.g., where 1 becomes 2, or said a different way when the minor points after 1 go higher than 1.99 ). The reason I'm looking for a formula that will return the cell location (e.g., A31) is to use it be able to apply another, separate formula in a row for each of the minor points.

In any event, I don't want a 200-input nested if/then statement if the major points rise to the level of 200 whole numbers

Thanks in advance for any insight into how I can attack this particular formula with one or several functions.

Thanks for the quick reply; I'm trying to do two things, with the simplest of the two being a formula output that returns the cell location (e.g., A23) rather than the cell value (e.g., "52"). Match and Index partly cover the issue but don't seem capable of returning the cell location.

Is there a standard way across all Excel formulas to have the location returned rather than the value of the cell itself? If not, then I'm stuck being able to move on to the next step.