VLOOKUP AND IF Formula

Ian Smith 2017

Good afternoon everyone, here looking for help again I'm afraid.

I have a quotations datasheet, and an original datasheet where I keep information on customer credit limits.

The quotations sheet currently has the following columns I'm trying to work with:

Value is manually entered, credit checked? and credit Limit are populated by a vlookup to my original datasheet.

If a customer is credit checked then the credit limit column will populate with that value from the my original datasheet, if there is no credit limit it will be blank.

My original datasheet has the following columns available:

So when credit checked is true, I'm needing the credit limit exceeded checkboxes on my quotations sheet to be true when the value on the quotations sheet exceeds the credit limit on my original datasheet.

Hints and tips gratefully received.

Ian Smith 2017

All sorted now :-)

Ian Smith 2017

All sorted now :-)

Genevieve P.

Hey @Ian Smith 2017

I'm glad you sorted it out! Thanks for letting us know.