How to reference different sheets and columns based on Criteria?

wbcroker

I am having trouble referencing data between two sheets.

What I am trying to do is in Sheet 1, if a cell in column A matches a cell in column A in Sheet 2, then return the value in column B of sheet 2 on the same row.

or in other terms for my specific project:

If program name in sheet 1 matches the program name in sheet 2, fill the course 1 associated with the program name in sheet 2 into the sheet 1

Paul Newcome

Try this:

=INDEX({Column To Pull From}, MATCH([Program Name]@row, {Program Name}, 0))