Hi,
I currently have a simple working formula using the Index/Small with Rows to generate a list of jobs a user is working on.
=INDEX($C$1:$D$10,SMALL(IF($D$1:$D$10=$L$2,ROW($D$1:$D$10)),ROW(2:2)),1)
$L$2 = User
I am trying to use the Indirect Function to test finding the data on another tab with the exact same data , but I am getting a #REF! error
=INDEX(INDIRECT("'"&L1&"'!"&$C$1:$D$10),SMALL(IF(INDIRECT("'"&L1&"'!"&$D$1:$D$10)=$L$2,ROW(INDIRECT("'"&L1&"'!"& (1:1)))),1))
L1= Feb This is the same name as the tab with the duplicate data.
Can anyone point me in the right direction?
I'm using the shift+Control+enter for the array.
I currently have a simple working formula using the Index/Small with Rows to generate a list of jobs a user is working on.
=INDEX($C$1:$D$10,SMALL(IF($D$1:$D$10=$L$2,ROW($D$1:$D$10)),ROW(2:2)),1)
$L$2 = User
I am trying to use the Indirect Function to test finding the data on another tab with the exact same data , but I am getting a #REF! error
=INDEX(INDIRECT("'"&L1&"'!"&$C$1:$D$10),SMALL(IF(INDIRECT("'"&L1&"'!"&$D$1:$D$10)=$L$2,ROW(INDIRECT("'"&L1&"'!"& (1:1)))),1))
L1= Feb This is the same name as the tab with the duplicate data.
Can anyone point me in the right direction?
I'm using the shift+Control+enter for the array.