Returning False with multiple Vlookups while completing formula in others

Hello there, first time poster in here. I am currently in Afghanistan working on a Leaders Book that I am trying to completely digitalize. I have a sheet that I use for Promotion schemes. I have made a small reference table on the right with the minimum Months needed to be promoted, but without a waiver and with one. I have created a formula that 1) tests to enusre that there is data in the row and if not, leaves all blank, 2) pulls the months needed criteria from the reference table and compares to the TIS and TIG columns to see if they are eligible. I have also put in a return statements of what I would like it to say. I am not super Excel savy, everything shown is what I have learned on my own, and attempted to put together. I should also note that the info on the left is pulled from another data sheet within the same workbook. I have seperated those links and changed names for privacy and security issues. I also have conditional formatting to where if it shows the value i want it pops up. I know and fully expect the ranks that have a (p) next to them to come back as n/a errors and I have no worries about that. However I have 3 different formulas in the I and J columns that the only difference is the placement of a single ")" on the end of the formula. I dont know why this seems to work with some of the guys and while others such as the one at the top it doesnt work at all. It states not eligible, but if you look, the TIG is 48 months, while the requirement is only 45, should be more than eligible, but will not display it. This is also the one formula that I have tried to use an AND statement with to see if that would fix it. You can see the other two just below that with other names. I have gone through Evaluating Formula to try and figure this out on my own, but I am at the end of my rope, and sadly not many around here understand Excel any more than I do lol. If someone could help look through this and see what I have done wrong? I have checked and rechecked every space, number, and cell format and they all check out. Just not sure why its not working with all the cells, and only some. Thank you!!!

can you just explain shortly what you trying to do?
I lost myself within your text:

for example: in cell I6 look if A6 something etc.
And Expected result.

Originally Posted by martindwilson

=IF(AND(G2>=VLOOKUP(A2,PromotionTable,3,FALSE),H2>=VLOOKUP(A2,PromotionTable,4,FALSE)),"Eligible","Not Eligible") will return eligible
but the numbers in your table "promotion table " are text numbers and text is always greater than a real number
put 0 in a spare cell copy -- select O4:R8 right click -paste special-add
this will change them to real numbers you may have to reformat cells as general

You my good man are a damn genius! I cant believe it was that bloody simple, I seriously have been cracked out on this for hours.....I had them labeled as numbers but for some reason I guess they just didnt register. As soon as I added the 0, it all clicked, then i just copied down the first formula with IF/AND and voila! That would explain why I went through the formula like 50 times and watched it say 48>45=FALSE....probably should have dawned on me then lol. Man, THANK YOU! And thanks to zbor as well, I probably didnt explain super well, this is all self taught crap, so I am still struggling with understanding all the ins and outs of excel coding. But this worked perfectly, now I can commplete my Leaders book and publish it out!