Table Results - Index Match for Row & Column returns incorrect values

I've attached the file where the operative function in column I that's giving me trouble is:

=INDEX(PPS[[0]:[61]],MATCH(D2,PPS[Months],0),MATCH(G2,PPS[[#Headers],[0]:[61]]))

The descriptive row is not to be referenced, merely easier for co-workers to read the table if needed.
The top table is a standard excel workspace.
The bottom table "PPS" is a formatted table for the referencing of the performance standard hours

I'm finding two problems really.

1) If someone with 10 or less months is searched, the table returns incorrect values. I'm lost in the sauce.
2) If the Tenure in Months column is manually changed and months are entered as a pure number, the formula in column I breaks. I don't understand why. While not imperative to what I'm trying to do, it would be nice to correct this or at least understand why.

No effect

I already tried the 1, 0, -1 there because it took me a long time in the first place to get the first half of the Match to work. 1 doesn't have an effect there, 0 only works if the tenure matches the minimum number column heading exact, so it's not useful if they are 1-3, 5-6, 8-9 months etc., -1 also breaks it.

I don't believe the values in "Months" column in the top and the Months headers in the bottom are being interpreted the same by excel. Try wrapping the "numbers" in NUMBERVALUE like this (in cell I2 and copy down):

=INDEX(PPS[[0]:[61]],MATCH(D2,PPS[Months],0),MATCH(NUMBERVALUE(G2),NUMBERVALUE(PPS[[#Headers],[0]:[61]]),1))

The months in row 26 and column G are both being treated as text. This causes both of your problems, firstly because numbers are not ordered the same way when stored as text (e.g. "10" is treated as less than "2" because it goes character by character), and secondly because if you replace column G with numbers then it's trying to compare a number with text and causes an error.

So the best way is to convert both your month ranges to numbers at source. If you want to keep the inputs as they are though, you could force them to numbers within the formula with something like this in I2, copied down:

=INDEX(PPS[[0]:[61]],MATCH(D2,PPS[Months],0),MATCH(G2+0,PPS[[#Headers],[0]:[61]]+0))

Both Gregb11 and nick.williams solutions worked! Thank you! I'd had a previous version of this where someone had me add *1 to the lookup value, I couldn't remember why but with both your answers this makes sense, but when I tried adding that this time it didn't work and I dont' know why.

The weird part is i tried changing both the G column and Row 26 to format of number, but that also didn't make a difference and I dont' know if i ever will at this point.

Glad it worked

The cell formatting doesn't (or at least doesn't usually) affect how Excel treats the actual value in the cell. e.g. if you type ="1" in a cell, and format it as a number, it will still be treated as text.

But you can "force" values to the right format, e.g.

Add &"" on the end will force something to text

Add +0 on the end will force something to a number (dates are numbers too). This will cause an error if it is not really a number though. So if you have "5"+0 it will force it to a number, but "text"+0 will just give an error.

You can alternatively use -- at the start, or multiply by 1, to force things to a number. Be careful that everything is enclosed in brackets when doing this e.g. ("5"&"5")*1 will be 55 (number), but "5"&"5"*1 becomes "5"&5 which becomes "55" (text).