Match cell value to data in another column and return adjasent value to another cell

I am trying to achieve this

If B56 (on Summary page) matches value in column B (on NPSSQL page) then put text from NPSSQL column C (next to matching value) in to cell F56

if I use this code it gives me the incorrect value in cell F56

=IFERROR(INDEX(NPSSQL!C:C,MATCH(B56,NPSSQL!B:B,0)),NPSSQL!C:C)