Index, Match, Collect and/or Vlookup?

Nancy Skoulphong
Nancy Skoulphong ✭✭✭✭
edited 08/27/20 in Formulas and Functions

Hello, may I get assistance with a formula? Thank you.

Sheet 1 ---> data in columns: Course Code, Section, Instructor

Sheet 2 ---> column names: Course Code, Section, Instructor (blank)

In sheet 2, I want to pull the instructor information from Sheet 1 based on course code and section in sheet 2.

Here's what I have but keep getting an error message. Help.

=INDEX(COLLECT({Instructor Schedule}, {Course Code Schedule}, [Course Code]@row, {Section Schedule}, Section@row, 0))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!