Need help duplicating a formula for different categories

[salgunaidi]

Hi all,

I'm currently creating a document (pdf) finder, I have attached the final version for you to see how it works.

The field named 'file path' has a formula which I would like to duplicate for another table that has a different set of dates. I will still be using the same format however there are different date ranges I will be using. This current excel worksheet is for 'A' Category, now I would like to generate another 4 that do not link to 'A' and that have their own value. So I would like to duplicate the formula to create 'B', 'C' and 'D' categories without them affecting 'A'. Is this possible?

A, B, C and D between them might have dates that are within the same ranges, however they all relate to different documents (pdf).

I hope you guys can help with this.

[daffodil11]

It should just be a matter of copying the formula from within the function editor, and pasting it into another cell.

You'll just need to change the references to match the new table.

=IFERROR(HYPERLINK(INDEX(Table1[pdf link],SUMPRODUCT((B13>=Table1[Date Start])*(B13<Table1[Date End])*Table1[Position]))),"Outside Date Range")

will become

=IFERROR(HYPERLINK(INDEX(Table2[pdf link],SUMPRODUCT((B13>=Table2[Date Start])*(B13<Table2[Date End])*Table2[Position]))),"Outside Date Range")