Hello.
I have attached a sheet which gives a benefit based on a benefit code from 1-9
The formula I created in range C8:C16 was created to validate based on quote in column A & ADA schedule in column D
Although this links to column H, I wonder if VLOOKUP formula could incorporate the benefit codes instead? Not sure how to setup
Column F is designed to give the lowest of the quote, ADA schedule or limit (range F2:F5)
I have spent hours trying to figure out the best formula for calculating the balance carried forward in F8:F16, I need the result to be either the maximum (highest) result if more than column C or D from range F2:F5
I have a formula which does sort of work but is incomplete
Thank you