Inquiry about HLOOKUP formula meaning

Please i want to know what do those formulas mean

1) =IF($B$14="","",IF(HLOOKUP('Concession - Output'!$B$14,Scenarios!$B$7:$AC$60,3)="","",HLOOKUP('Concession - Output'!$B$14,Scenarios!$B$7:$AC$60,3)))


2) =IF(B16="",0,INDEX('Offers Cost Impact'!$B$3:$F$54,MATCH(B16,'Offers Cost Impact'!$B$3:$B$54,0),MATCH('Concession - Output'!$B$10,'Offers Cost Impact'!$B$3:$F$3,0)))


P.S: There are five sheets which are Concession - Output,Segmentation Criteria,Offers Cost Impact,Scenarios and reference

thanks in advance ^.^