Assuming the named range is a single column, then something like:
=IF($I$12=TRUE,INDEX(Payer_Verify,ROWS($A$1:$A1)),"")
copied down
else if it is multicolumn.
=IF($I$12=TRUE,INDEX(Payer_Verify,ROWS($A$1:$A1),COLUMNS($A$1:A$1)),"")
copied across and down
Bookmarks