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