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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!