HOMEへ

=MATCH(Sheet2!$B$2&Sheet2!C4,Sheet1!$A:$A&Sheet1!$G:$G,0)

=IF(INDIRECT("Sheet1!A"&$C$19)="","N/A",INDIRECT("Sheet1!A"&$C$19))
=IF(INDIRECT("Sheet1!B"&$C$19)="","N/A",INDIRECT("Sheet1!B"&$C$19))
=IF(INDIRECT("Sheet1!C"&$C$19)="","N/A",INDIRECT("Sheet1!C"&$C$19))
=IF(INDIRECT("Sheet1!D"&$C$19)="","N/A",INDIRECT("Sheet1!D"&$C$19))
=IF(INDIRECT("Sheet1!E"&$C$19)="","N/A",INDIRECT("Sheet1!E"&$C$19))
=IF(INDIRECT("Sheet1!F"&$C$19)="","N/A",INDIRECT("Sheet1!F"&$C$19))
=IF(INDIRECT("Sheet1!G"&$C$19)="","N/A",INDIRECT("Sheet1!G"&$C$19))
=IF(INDIRECT("Sheet1!H"&$C$19)="","N/A",INDIRECT("Sheet1!H"&$C$19))
=IF(INDIRECT("Sheet1!I"&$C$19)="","N/A",INDIRECT("Sheet1!I"&$C$19))
=IF(INDIRECT("Sheet1!J"&$C$19)="","N/A",INDIRECT("Sheet1!J"&$C$19))
=IF(INDIRECT("Sheet1!K"&$C$19)="","N/A",INDIRECT("Sheet1!K"&$C$19))
=IF(INDIRECT("Sheet1!L"&$C$19)="","N/A",INDIRECT("Sheet1!L"&$C$19))
=IF(INDIRECT("Sheet1!M"&$C$19)="","N/A",INDIRECT("Sheet1!M"&$C$19))
=IF(INDIRECT("Sheet1!N"&$C$19)="","N/A",INDIRECT("Sheet1!N"&$C$19))