Im so sorry I reuploaded without protect and fixed the cells to the correct ones. It kinda works now, what doesnt work is if the amount in G36 is less than 2,200.00 then G38 should display INELEGABLE but instead it shows a zero.
Fixed cells to:
![]()
=IF(G36="","",IF(G36<'Benefit Rate Tbl'!C5,F5,VLOOKUP(G36,'Benefit Rate Tbl'!C5:F263,4,1)))
Bookmarks