Excel Hyperlink with Concatenate or Indirect

Excel Hyperlink with Concatenate or Indirect

How does Excel Hyperlink formula work with either Concatenate or Indirect
formula inside? Thank you,
=HYPERLINK(CONCATENATE("'[Purchase Order Template1.xlsx]PO Mgmt
Log'!A",MATCH(C6,PO_ID,0)),"LINK")
=HYPERLINK(CELL("address",INDIRECT("'PO Mgmt
Log'!A"&MATCH(C6,PO_ID))),"LINK")