Comparing two excel workbooks and if columns match get value from corresponding column

Hi

I'm using two workbooks and looking to see if two columns match, then value in the cell should be the corresponding value of that cell.

For example:

Currently, I'm using

Currently it looks like this

=IF(ISNA(MATCH(C2,'[Spreadsheet.xlsx'!$F$3:$F$162,0)), How do I incorporate the fact that if C2 and "spreadsheet.xlsx" match then find the corresponding value in column "BY" of spreadsheet.xlsx, "Not in raw data")

Is there a way to incorporate in formula

Thanks