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

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!