Formula
Hi
I have a scenario like below
If Award Type is MP, then Vlook up buyer name
If Award Type is non MP and Approval required is tick, then vlookup buyer name
The formula that I am thinking as below, but i think it is wrong. Can help to show me the correct formula
=IF(AND([Approval]@row = "Yes", [Award Type]@row="Non MP")), OR([Award Type]]@row = "MP", VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
Best Answer
-
I apologize I had a typo in the formulas. I corrected them below
=IF(OR(AND([Approval]@row = 1, [Award Type]@row="Non MP"), [Award Type]@row = "MP"), VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
Or use
=IF(OR(AND([Approval]@row = "Yes", [Award Type]@row="Non MP"), [Award Type]@row = "MP"), VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
Hi,
It seems that the Vlookup is the same either way right? What are the return values? can you send some screenshots please?
Are there any other options that are different than MP/non MP?
Thanks
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
check boxes are Boolean. meaning they are 1 or 0. To get your formula to work.
=IF(OR(AND([Approval]@row = 1, [Award Type]@row="Non MP"), [Award Type]]@row = "MP"), VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
If it is not a check box then you need the below formula
=IF(OR(AND([Approval]@row = "Yes", [Award Type]@row="Non MP"), [Award Type]]@row = "MP"), VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Hi @Mark.poole
the formula that you have told is giving me Incorrect argument error. Need your help to advise. Thanks
-
I apologize I had a typo in the formulas. I corrected them below
=IF(OR(AND([Approval]@row = 1, [Award Type]@row="Non MP"), [Award Type]@row = "MP"), VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
Or use
=IF(OR(AND([Approval]@row = "Yes", [Award Type]@row="Non MP"), [Award Type]@row = "MP"), VLOOKUP(Commodity@row, {BuyerRange 1}, 3, 0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Hi @Mark.poole Thanks for the help to show the correct way.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!