VLOOKUP AND IF Formula
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
-
All sorted now :-)
Answers
-
All sorted now :-)
-
Hey @Ian Smith 2017
I'm glad you sorted it out! Thanks for letting us know.
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!