VLOOKUP AND IF Formula

Options

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.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!