Index & Match Formula with Unique Values bases on a criteria

Dear Experts,

Please find here attached workbook, I am looking for formula based on criteria is at Cell B3 and B10 in Sheet1 and based on these two criteria i am looking for the unique CATEGORY values to be appeared which are in List tab.

Thank you for your precious support and valuable phase.

Regards,

Neilesh

In B4:
=INDEX(List!$B$3:$B$9,MATCH(0,IF($B$3=List!$C$3:$C$9,COUNTIF($B$3:B3,List!$B$3:$B$9),""),0))

Confirmed as array (CTRL+SHIFT+ENTER). Copy down

In B11:
=INDEX(List!$B$3:$B$9,MATCH(0,IF($B$10=List!$C$3:$C$9,COUNTIF($B$10:B10,List!$B$3:$B$9),""),0))

Confirmed as array (CTRL+SHIFT+ENTER). Copy down

Thank you very much expert for providing your valuable support and precious phase. Can you please also provide the formula for unique values in Sheet1 from two different worksheets as attached for Forecast and Actual tab.

Once again thank you for your precious phase and valuable support.

Regards,

Neilesh

Originally Posted by canapone

Hi,

I'm exploiting Ck76's job.

In B4

=IFERROR(IFERROR(INDEX(Forecast!$B$3:$B$9,MATCH(0,IF($B$3=Forecast!$C$3:$C$9,COUNTIF($B$3:B3,Forecast!B$3:$B$9),""),0)),INDEX(Actual!$B$3:$B$9,MATCH(0,IF($B$3=Actual!$C$3:$C$9,COUNTIF($B$3:B3,Actual!$B$3:$B$9),""),0))),"")


In B11

=IFERROR(IFERROR(INDEX(Forecast!$B$3:$B$9,MATCH(0,IF($B$10=Forecast!$C$3:$C$9,COUNTIF($B$10:B10,Forecast!B$3:$B$9),""),0)),INDEX(Actual!$B$3:$B$9,MATCH(0,IF($B$10=Actual!$C$3:$C$9,COUNTIF($B$10:B10,Actual!$B$3:$B$9),""),0))),"")


Formulae need array status before to be copied down.

Regards

Thank you so much Expert for your precious support and valuable contribution.

Regards,

Neilesh