Vlookup cross sheet help

Nancy Skoulphong

Greetings! I am struggling with a vlookup formula.

I want to auto-populate data the IPC Name and IPC Email from sheet 2 based on the campus entered in sheet 1. 

I have tried variations and keep getting invalid data type. Help

=VLOOKUP([Campus]@row, {Sheet2 3}, {Sheet2 2}, false)

Faith Glass-Wilson

The basic formula is =VLOOKUP(search_value,lookup_table,column_num,[match_type]

Here's the formula you need: 

=IFERROR(VLOOKUP(Campus@row, {Sheet 2 Range 1}, 2, false), "No Match")