A formula that shows only the list with non-empty values

[Omer_K]

Dear all,
I have a table (I have added a table with pictorial values) with quite a bit of data, under there is another table divided by countries with INDEX and MATCH, as you can see not every country has values,
I would like to have only non-empty countries in the list. According to the example, the material Biomaterials is not found in USA and JAPAN and therefore the table below will show me only the countries Canada, Brazil and Mexico
I wish you will understand..

(I hope it can be solve by formula)

Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​

[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

USA​

[/TD]
[TD="bgcolor: #E2EFDA"]

USA​

[/TD]
[TD="bgcolor: #E2EFDA"]

USA​

[/TD]
[TD="bgcolor: #E2EFDA"]

Canada​

[/TD]
[TD="bgcolor: #E2EFDA"]

Canada​

[/TD]
[TD="bgcolor: #E2EFDA"]

Canada​

[/TD]
[TD="bgcolor: #E2EFDA"]

Brazil​

[/TD]
[TD="bgcolor: #E2EFDA"]

Brazil​

[/TD]
[TD="bgcolor: #E2EFDA"]

Brazil​

[/TD]
[TD="bgcolor: #E2EFDA"]

Japan​

[/TD]
[TD="bgcolor: #E2EFDA"]

Japan​

[/TD]
[TD="bgcolor: #E2EFDA"]

Japan​

[/TD]
[TD="bgcolor: #E2EFDA"]

Mexico​

[/TD]
[TD="bgcolor: #E2EFDA"]

Mexico​

[/TD]
[TD="bgcolor: #E2EFDA"]

Mexico​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​

[/TD]
[TD="bgcolor: #002060"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Metrial[/COLOR][/TD]
[TD="bgcolor: #E2EFDA"]

%​

[/TD]
[TD="bgcolor: #E2EFDA"]

Result​

[/TD]
[TD="bgcolor: #E2EFDA"]

No.​

[/TD]
[TD="bgcolor: #E2EFDA"]

%​

[/TD]
[TD="bgcolor: #E2EFDA"]

Result​

[/TD]
[TD="bgcolor: #E2EFDA"]

No.​

[/TD]
[TD="bgcolor: #E2EFDA"]

%​

[/TD]
[TD="bgcolor: #E2EFDA"]

Result​

[/TD]
[TD="bgcolor: #E2EFDA"]

No.​

[/TD]
[TD="bgcolor: #E2EFDA"]

%​

[/TD]
[TD="bgcolor: #E2EFDA"]

Result​

[/TD]
[TD="bgcolor: #E2EFDA"]

No.​

[/TD]
[TD="bgcolor: #E2EFDA"]

%​

[/TD]
[TD="bgcolor: #E2EFDA"]

Result​

[/TD]
[TD="bgcolor: #E2EFDA"]

No.​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Biomaterials​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

31%​

[/TD]
[TD]

strong​

[/TD]
[TD][/TD]
[TD]

8%​

[/TD]
[TD]

easy​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

34%​

[/TD]
[TD]

short​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Ceramics​

[/TD]
[TD]

32%​

[/TD]
[TD]

short​

[/TD]
[TD]

13​

[/TD]
[TD][/TD]
[TD]

easy​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

long​

[/TD]
[TD][/TD]
[TD]

26%​

[/TD]
[TD]

strong​

[/TD]
[TD]

12​

[/TD]
[TD]

79%​

[/TD]
[TD][/TD]
[TD]

14​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Composites​

[/TD]
[TD]

59%​

[/TD]
[TD]

long​

[/TD]
[TD]

14​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

97%​

[/TD]
[TD]

med​

[/TD]
[TD][/TD]
[TD]

77%​

[/TD]
[TD]

long​

[/TD]
[TD]

21​

[/TD]
[TD][/TD]
[TD]

short​

[/TD]
[TD]

4​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Concrete​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD]

long​

[/TD]
[TD][/TD]
[TD]

80%​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

5​

[/TD]
[TD]

33%​

[/TD]
[TD]

med​

[/TD]
[TD]

5​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Electronic / Optical​

[/TD]
[TD][/TD]
[TD]

med​

[/TD]
[TD]

9​

[/TD]
[TD]

18%​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

22​

[/TD]
[TD]

80%​

[/TD]
[TD]

short​

[/TD]
[TD]

18​

[/TD]
[TD][/TD]
[TD]

short​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Glass​

[/TD]
[TD]

43%​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

75%​

[/TD]
[TD]

med​

[/TD]
[TD][/TD]
[TD]

1%​

[/TD]
[TD]

easy​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Metals​

[/TD]
[TD]

80%​

[/TD]
[TD]

med​

[/TD]
[TD]

9​

[/TD]
[TD]

62%​

[/TD]
[TD][/TD]
[TD]

6​

[/TD]
[TD]

59%​

[/TD]
[TD][/TD]
[TD]

19​

[/TD]
[TD]

30%​

[/TD]
[TD]

strong​

[/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD]

short​

[/TD]
[TD]

18​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

Metamaterials​

[/TD]
[TD][/TD]
[TD]

long​

[/TD]
[TD]

12​

[/TD]
[TD]

90%​

[/TD]
[TD]

strong​

[/TD]
[TD]

10​

[/TD]
[TD]

8%​

[/TD]
[TD]

short​

[/TD]
[TD]

20​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

83%​

[/TD]
[TD]

med​

[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​

[/TD]
[TD="bgcolor: #FCE4D6"]

<== Select Metrial From The List​

[/TD]
[TD="bgcolor: #FCE4D6"][/TD]
[TD="bgcolor: #FCE4D6"][/TD]
[TD="bgcolor: #FFF2CC"]Biomaterials[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

%​

[/TD]
[TD="bgcolor: #E2EFDA"]

Result​

[/TD]
[TD="bgcolor: #E2EFDA"]

No.​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

USA​

[/TD]
[TD="bgcolor: #FFF2CC"]

0%​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

Canada​

[/TD]
[TD="bgcolor: #FFF2CC"]

31%​

[/TD]
[TD="bgcolor: #FFF2CC"]

strong​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

Brazil​

[/TD]
[TD="bgcolor: #FFF2CC"]

8%​

[/TD]
[TD="bgcolor: #FFF2CC"]

easy​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

Japan​

[/TD]
[TD="bgcolor: #FFF2CC"]

0%​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]

Mexico​

[/TD]
[TD="bgcolor: #FFF2CC"]

34%​

[/TD]
[TD="bgcolor: #FFF2CC"]

short​

[/TD]
[TD="bgcolor: #FFF2CC"]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]23[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]24[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]25[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

Cell G18:
{=INDEX($B$3:$P$10,MATCH($D$16,$A$3:$A$10,0),MATCH($F18&G$17,$B$1:$P$1&$B$2:$P$2,0))}​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]26[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]27[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]28[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: DataBase[/TD]
[/TR]
</tbody>[/TABLE]



Thank you so much...

Omer.

 

[Aladin Akyurek]

Do not try to post big chunks, just enough to show how your data looks like. Avoid also showing any formulas. And give the desired result(s) for the sample you posted.

 

[Omer_K]

Now it's OK?

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td][/td][td=bgcolor:#FFFFFF]

USA​

[/td][td=bgcolor:#FFFFFF]

USA​

[/td][td=bgcolor:#FFFFFF]

Canada​

[/td][td=bgcolor:#FFFFFF]

Canada​

[/td][td=bgcolor:#FFFFFF]

Brazil​

[/td][td=bgcolor:#FFFFFF]

Brazil​

[/td][td=bgcolor:#FFFFFF]

Japan​

[/td][td=bgcolor:#FFFFFF]

Japan​

[/td][td=bgcolor:#FFFFFF]

Mexico​

[/td][td=bgcolor:#FFFFFF]

Mexico​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td=bgcolor:#002060]Metrial[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

Biomaterials​

[/td][td]

​

[/td][td]

​

[/td][td]

31%​

[/td][td]

strong​

[/td][td]

8%​

[/td][td]

easy​

[/td][td]

​

[/td][td]

​

[/td][td]

34%​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

Ceramics​

[/td][td]

32%​

[/td][td]

short​

[/td][td]

​

[/td][td]

easy​

[/td][td]

​

[/td][td]

long​

[/td][td]

26%​

[/td][td]

strong​

[/td][td]

79%​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

Composites​

[/td][td]

59%​

[/td][td]

long​

[/td][td]

​

[/td][td]

​

[/td][td]

97%​

[/td][td]

med​

[/td][td]

77%​

[/td][td]

long​

[/td][td]

​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

Concrete​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

long​

[/td][td]

80%​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

33%​

[/td][td]

med​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

Electronic / Optical​

[/td][td]

​

[/td][td]

med​

[/td][td]

18%​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

80%​

[/td][td]

short​

[/td][td]

​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

Glass​

[/td][td]

43%​

[/td][td]

​

[/td][td]

75%​

[/td][td]

med​

[/td][td]

1%​

[/td][td]

easy​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

Metals​

[/td][td]

80%​

[/td][td]

med​

[/td][td]

62%​

[/td][td]

​

[/td][td]

59%​

[/td][td]

​

[/td][td]

30%​

[/td][td]

strong​

[/td][td]

​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

Metamaterials​

[/td][td]

​

[/td][td]

long​

[/td][td]

90%​

[/td][td]

strong​

[/td][td]

8%​

[/td][td]

short​

[/td][td]

​

[/td][td]

​

[/td][td]

83%​

[/td][td]

med​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td=bgcolor:#FFFFFF]

<== Select Metrial From The List​

[/td][td=bgcolor:#FFFFFF]

​

[/td][td=bgcolor:#FFFFFF]

​

[/td][td=bgcolor:#FFFFFF]Biomaterials[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

%​

[/td][td=bgcolor:#E2EFDA]

Result​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

USA​

[/td][td=bgcolor:#FFFFFF]

0%​

[/td][td=bgcolor:#FFFFFF]

0​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Canada​

[/td][td=bgcolor:#FFFFFF]

31%​

[/td][td=bgcolor:#FFFFFF]

strong​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Brazil​

[/td][td=bgcolor:#FFFFFF]

8%​

[/td][td=bgcolor:#FFFFFF]

easy​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

18​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Japan​

[/td][td=bgcolor:#FFFFFF]

0%​

[/td][td=bgcolor:#FFFFFF]

0​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

19​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Mexico​

[/td][td=bgcolor:#FFFFFF]

34%​

[/td][td=bgcolor:#FFFFFF]

short​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

20​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

21​

[/td][td][/td][td]

Cell G15:
{=INDEX($B$3:$P$10,MATCH($D$16,$A$3:$A$10,0),MATCH($F18&G$17,$B$1:$P$1&$B$2:$P$2,0))}​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

22​

[/td][td][/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

23​

[/td][td][/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: DataBase[/td][/tr][/table]

 

[Omer_K]

The small table is what i would like...

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td][/td][td=bgcolor:#FFFFFF]

USA​

[/td][td=bgcolor:#FFFFFF]

USA​

[/td][td=bgcolor:#FFFFFF]

Canada​

[/td][td=bgcolor:#FFFFFF]

Canada​

[/td][td=bgcolor:#FFFFFF]

Brazil​

[/td][td=bgcolor:#FFFFFF]

Brazil​

[/td][td=bgcolor:#FFFFFF]

Japan​

[/td][td=bgcolor:#FFFFFF]

Japan​

[/td][td=bgcolor:#FFFFFF]

Mexico​

[/td][td=bgcolor:#FFFFFF]

Mexico​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td=bgcolor:#002060]Metrial[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][td=bgcolor:#FFFFFF]

%​

[/td][td=bgcolor:#FFFFFF]

Result​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

Biomaterials​

[/td][td]

​

[/td][td]

​

[/td][td]

31%​

[/td][td]

strong​

[/td][td]

​

[/td][td]

easy​

[/td][td]

​

[/td][td]

​

[/td][td]

34%​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

Ceramics​

[/td][td]

32%​

[/td][td]

short​

[/td][td]

​

[/td][td]

easy​

[/td][td]

​

[/td][td]

long​

[/td][td]

26%​

[/td][td]

strong​

[/td][td]

79%​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

Composites​

[/td][td]

59%​

[/td][td]

long​

[/td][td]

​

[/td][td]

​

[/td][td]

97%​

[/td][td]

med​

[/td][td]

77%​

[/td][td]

long​

[/td][td]

​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

Concrete​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

long​

[/td][td]

80%​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

33%​

[/td][td]

med​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

Electronic / Optical​

[/td][td]

​

[/td][td]

med​

[/td][td]

18%​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

80%​

[/td][td]

short​

[/td][td]

​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

Glass​

[/td][td]

43%​

[/td][td]

​

[/td][td]

75%​

[/td][td]

med​

[/td][td]

1%​

[/td][td]

easy​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

Metals​

[/td][td]

80%​

[/td][td]

med​

[/td][td]

62%​

[/td][td]

​

[/td][td]

59%​

[/td][td]

​

[/td][td]

30%​

[/td][td]

strong​

[/td][td]

​

[/td][td]

short​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

Metamaterials​

[/td][td]

​

[/td][td]

long​

[/td][td]

90%​

[/td][td]

strong​

[/td][td]

8%​

[/td][td]

short​

[/td][td]

​

[/td][td]

​

[/td][td]

83%​

[/td][td]

med​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#FFFFFF]Biomaterials[/td][td=bgcolor:#E2EFDA]

%​

[/td][td=bgcolor:#E2EFDA]

Result​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Canada​

[/td][td=bgcolor:#FFFFFF]

31%​

[/td][td=bgcolor:#FFFFFF]

strong​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Brazil​

[/td][td=bgcolor:#FFFFFF]

0%​

[/td][td=bgcolor:#FFFFFF]

easy​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

Mexico​

[/td][td=bgcolor:#FFFFFF]

34%​

[/td][td=bgcolor:#FFFFFF]

short​

[/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: DataBase[/td][/tr][/table]





Thank you,

 

[Aladin Akyurek]

Regarding post #4 , we have an empty cell for Brazil in the Biomaterials row, but a Result value of easy. Is the latter the reason we have Brazil in our output list?

 

[Omer_K]

Hey,
That's right,
only the countries that % and result are empty (both of them) will not appear on the small table,
otherwise, such as Brazil that one of them not empty should appear on the smaill table.

 

[Aladin Akyurek]

Hey,
That's right,
only the countries that % and result are empty (both of them) will not appear on the small table,
otherwise, such as Brazil that one of them not empty should appear on the smaill table.

Thanks for the appropriate Excel readable visual, desired results, and the clarification.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		USA	USA	Canada	Canada	Brazil	Brazil	Japan	Japan	Mexico	Mexico
2	Metrial	%	Result	%	Result	%	Result	%	Result	%	Result
3	Biomaterials			31%	strong		easy			34%	short
4	Ceramics	32%	short		easy		long	26%	strong	79%
5	Composites	59%	long			97%	med	77%	long		short
6	Concrete				long	80%				33%	med
7	Electronic / Optical		med	18%				80%	short		short
8	Glass	43%		75%	med	1%	easy
9	Metals	80%	med	62%		59%		30%	strong		short
10	Metamaterials		long	90%	strong	8%	short			83%	med
11
12
13						Biomaterials	%	Result
14					3	Canada	0.31	strong
15					5	Brazil	0	easy
16					9	Mexico	0.34	short
17
Sheet1

In E14 control+shift+enter, not just enter, and copy down:

=IFERROR(SMALL(IF(ISNUMBER(INDEX($B$3:$J$10,MATCH($F$13,$A$3:$A$10,0),0))+ISTEXT(INDEX($C$3:$K$10,MATCH($F$13,$A$3:$A$10,0),0)),COLUMN($B$1:$J$1)-COLUMN($B$1)+1),ROWS($1:1)),"")

In F14 just enter and copy down:

=IF($E14="","",INDEX($B$1:$K$1,$E14))

In G14 control+shift+enter, not just enter, copy across to H14, and down:

=IF($E14="","",INDEX($B$3:$K$10,MATCH($F$13,$A$3:$A$10,0),MATCH(1,($B$1:$K$1=$F14)*($B$2:$K$2=G$13),0)))

 

[Omer_K]

Dear Aladin,
you are the best!!

It works perfect
I really appreciate it
Thank you!

 

[Aladin Akyurek]

Dear Aladin,
you are the best!!

It works perfect
I really appreciate it
Thank you!

You are welcome. Glad to be of help.

 

[Omer_K]

Hey All,
If I would like to add for each country 1 more column,
such as:
For USA 3 column - 1 for %, one for result and one for density,
the same for Canada (3 columns) and all the countris,

what I should change in the formula?

=IFERROR(SMALL(IF(ISNUMBER(INDEX($B$3:$J$10,MATCH($F$13,$A$3:$A$10,0),0))+ISTEXT(INDEX($C$3:$K$10,MATCH($F$13,$A$3:$A$10 ,0),0)),COLUMN($B$1:$J$1)-COLUMN($B$1)+1),ROWS($1:1)),"")

thank you so much.