Formula

[rollingzep]

Hi All,

I have an application, which i got from the earlier person, who left the organization.
I was able to restore most of the worksheets in the workbook and their values.

But on one tab, (Day Start) of the Workbook, I see the below two formulas but couldn't make anything on that.

=IFERROR(SMALL(OFFSET(INDIRECT(ADDRESS(52,MATCH("*Collateral pledged at ancillary systems*",$A$51:$BM$51,0),4,1,)),0,0,COUNTA($Q$52:$Q$352),1),1),"-")
=IFERROR(SMALL(OFFSET(INDIRECT(ADDRESS(52,MATCH("Other",$A$51:$BM$51,0),4,1,)),0,0,COUNTA($Q$52:$Q$352),1),1),"-")

While I see the field with value "Collateral pledged at ancillary systems" on two of the other WS (reportData and Pos data) , I am not sure of this range($A$51:$BM$51) and which WS it points to.

If you need more details, I can provide.

TIA

 

[dreid1011]

Without a qualifying sheet name in front of the range, it would be pointing to the sheet the formula is on. However, not having the data on the Day Start worksheet to look at, it could be pointing to another sheet because of the INDIRECT function.