IF cross-sheet formulas with conditions
I'm working in a sheet column and trying to pull data from another sheet BUT pull data from two different columns based on IF this row matches data in another column.
Here's the current formula that only pulls "Schedule Notes" from another sheet when it matches the Course Numbers.
=IFERROR(INDEX({Course List Worksheet - Schedule Notes}, MATCH([LD Course Number]@row, {Course List - Course Number}, 0)), "")
The above formula works for the one condition, that it matches the course number, but I have split the schedule notes into two separate columns that are separated by the conditions "RI" or "WC".
Here is the formula I am trying to create to add a condition where IF([WC/RI]@row = "RI" it would IFERROR(INDEX({Course List Worksheet - Schedule Notes RI}, MATCH([LD Course Number]@row, {Course List - Course Number}, 0)), "") AND IF([WC/RI]@row = "WC" it would IFERROR(INDEX({Course List Worksheet - Schedule Notes WC}, MATCH([LD Course Number]@row, {Course List - Course Number}, 0)), "")
Any suggestions or advice you can give on how to cross-sheet reference from two columns based on the data in another @row cell would be greatly appreciated!!
Answers
-
Hi Alison Laninger
I hope you are doing well,
You can this formula you can create two separate columns or separate conditions, this one for Schedule notes RI - =IF(INDEX({Schedule notes RI}, MATCH([Course Number]@row, {Course Number}, 0)) = "RI", "RI",””)
And this one for Schedule notes WC - =IF(INDEX({Schedule notes WC}, MATCH([Course Number]@row, {Course Number}, 0)) = "WC", "WC", "")
I hope this is useful to you, please let me know if you need any other help.
Thanks,
Kaveri Vipat
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!