The following formula is meant to create a range of the last payroll listing using the payroll date as a filter. After each payday, the list of those who were paid is added to an ongoing list. The data is sorted in order to ensure that all common dates are together. The formula works fine when placed in a cell.

="Listing!A"&(COUNTA(Listing!Z:Z)-COUNTIF(Listing!Z:Z,INDIRECT("listing!Z"&COUNTA(Listing!Z:Z))))&":Z"&COUNTA(Listing!Z:Z)

However, when I copy it as is into the Name Manager, naming it 'myRng'; nothing when using the following formula

=IFERROR(VLOOKUP(A2,INDIRECT(myRng),6,FALSE),"Not Listed"). Here I am comparing the payroll listing to a listing of authorized positions and their respective pay grades. A tool to be used to make sure raises remain within budget.