Comination formula with IF and VLOOKUP, returning opposite results

[Jessicam3]

I have a complex formula going and for some reason the only way it returns the correct answer on the last portion of the formula is if the greater/less than sign is flipped around? I enlarged the specific sign that I have currently have flipped around so the formula works, but the way it should read is that if the vlookup is greater than, not less than. Can anyone help with this? Thanks!

=IF(F28=1,IF(VLOOKUP(G28,$AB$2:$AC$15,2,FALSE)>=T28,T28,T28+U28),IF(VLOOKUP(F28,$Z$2:$AA$26,2,FALSE)<=T28,T28,T28+U28))

 

[Jessicam3]

I couldn't get your formula to work, but I also had to manually type it. I couldn't copy it from your reply into excel. so it could have been my typing error.
But I did get these to work
Column T .... =IF(F28=1,IF(VLOOKUP(G28,$AB$2:$AC$14,2,FALSE)<=(O28+S28),O28,O28+S28),IF(VLOOKUP(F28,$Z$2:$AA$26,2,FALSE)<=(O28+S28),P28,O28+S28))
Column U.... =IF(F28=1,IF(VLOOKUP(G28,$AB$2:$AC$15,2,FALSE)<=(T28+U28),P28,T28+U28),IF(VLOOKUP(F28,$Z$2:$AA$26,2,FALSE)<=(T28+U28),P28,T28+U28))
Column X .... =IF(P28=V28,(((O28+U28+S28)-V28)*N28*26),0)


I really appreciate you taking time to work through this with me, it is great to find a space to bounce ideas off of. thank you!

 

[Fluff]

Glad you sorted it & thanks for letting us know.