IF cross-sheet formulas with conditions

Alison Laninger

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!!

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.