# If & carried forward balances

• 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

## Files

• Re: If &amp; carried forward balances

Do you mean replace the direct reference to column H with a Vlookup?

e.g.

[COLOR="#0000FF"]=IF(D8>0,D8*B8, A8*VLOOKUP(E8,\$G\$8:\$H\$16,2,0))[/COLOR]

Where there is a will there are many ways. Finding one that works for you is the challenge!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!