Data validation and formula - Google Sheets

Hello,

I have a really silly question but I can't think of a way and I hope someone here can help.

In my tab number 1, I created a data validation that picks up either developing or developed countries.

I would like to create a table below this that picks up the countries that are in developing or developed countries from my tab number 2.

For example, I selected developed in my data validation. My table should show up all the countries that are classified developed in my second tab.

Please help!

ok title changed

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

I think this is what you are after:

=COUNTIFS(Sheet2!A2:A5,"<>",Sheet2!B2:B5,Sheet1!D8)

OK - then your sample sheet was not at all clear! Yes, it is possible:

Excel 2016 (Windows) 32 bit

	C	D	E
8	SELECT MARKET	developed
9
10	Countries
11	FRANCE
12	UK
13	JAPAN

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	C
11	=IFERROR(INDEX(Sheet2!A:A,SMALL(IF(Sheet2!$B$2:$B$21=$D$8,ROW(Sheet2!$A$2:$A$21)),ROWS($A$1:A1))),"")

Sheet: Sheet1

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Why did you not say this at the start? This is an Excel forum: if you are using something else, then you should be posting in a different section. I cannot help you with Google Sheets, sorry, but I will move your posts for you and amend the thread title.