Match Function

Can someone explain this function to me in lamens terms?

=MATCH(9.999999E+307,B12:Y12)-1

=MATCH(9.999999E+307,B18:Y18)-1

So what is this pulling and how does it change depending on the data?

Thanks!

Generally speaking the formula is designed to locate the last number in the specified range - and once found it subtracts one from the column index...

Should for ex. the last number in B12:Y12 be located in D12 the MATCH would return 3 (number found in 3rd column) from which 1 would be subtracted resulting in 2

It looks for the position of the last cell containing a number in those ranges, and then moves up one cell from that....

the Match() function looks for a position within a specified range and when used without the 0 as last condition, it looks for closest match.... (smallest number less than or equal to search value)..

9.999999e+307 is the largest number Excel recognizes and so it looks for that number in the range and can't find it, so it returns the position of the last number it finds that is smaller than or equal to 9.999999e+307