Need some help with a problem in Google Spreadsheets (tables)

I need a little help with a Google Spreadsheet (table).

I have a Spreadsheet with three tables:

1. Names

Just a list of some people´s names

2. Pets Names

Here I have the people´s names in column A and the names of their pets in column B. As some people have several pets, there are several lines with the same person´s name in A, with different pets names in B.

In a third table I can select the Names from the table “Names” in column A. What I need now is the following: When I select a Name in column A, I need a dropdown list with all pets of this person appearing in column B.

If you get awarded with the job, I´ll give you access to the spreadsheet, so you can work on it.

I need a solution that I can easily transfer into another spreadsheet (since this is obviously only a sample for testing). I cannot give you access to the original one. So you will have to explain, how I can transfer it. I work a lot with tables (Excel & Google Spreadsheet), but keep in mind that I´m not a developer.

So please note: If your solution needs a technical advanced person to include it in the original spreadsheet, it´s not the solution that I´m looking for and you won´t get a payment!

Навыки: Excel, Ввод данных, Обработка данных

О клиенте:
( 11 отзыв(-а, -ов) ) Bad Erlach, Austria

ID проекта: #34368192

86 фрилансеров(-а) готовы выполнить эту работу в среднем за €51

(1171 отзывов(-а))
(526 отзывов(-а))
(551 отзывов(-а))
(95 отзывов(-а))

I have a huge Google Sheets experience (with 1,000+ reviews) and I can show you how you can generate dynamic dropdowns based on your data. Could you show your spreadsheet? Roman

€30 EUR за 1 день
(217 отзывов(-а))
(100 отзывов(-а))
(112 отзывов(-а))
(125 отзывов(-а))

Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need Больше

€35 EUR за 1 день
(184 отзывов(-а))
(96 отзывов(-а))
(93 отзывов(-а))

I can help with a problem in Google Spreadsheets (tables) I will provide 100% quality. I'm ready to start the task. Please send me a message for discussion. Let's discuss the job. Thank

€15 EUR за 1 день
(34 отзывов(-а))
(11 отзывов(-а))
(13 отзывов(-а))
(29 отзывов(-а))

Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I am ready to start work right now and can assure the best service from my end. Waiting for your good res Больше

€20 EUR за 1 день
(16 отзывов(-а))

"Dear employer, I had read your requirement for Need some help with a problem in Google Spreadsheets (tables). I am expert in this field. That's why I placed my bid on this project. I'm a professional in data entry, we Больше

€15 EUR за 1 день
(15 отзывов(-а))

Hi, I have checked the project : i shall give you 100% accuracy with timely deliver the project. To proceed further, I am ready to discuss your project and start immediately. Thanks

€19 EUR за 1 день
(23 отзывов(-а))

Hello, Please review my profile as I have the relevant skills and experience required for this project. I can start working right now. Kindly send me a message to discuss further for references, portfolio, and case s Больше

€30 EUR за 1 день
(7 отзывов(-а))

Dear, hiring manager. I am pretty sure I can give you great satisfaction. I can start working right away if you 'd like me to get started. I will do my best and looking forward to working for you. Thanks.

€20 EUR за 7 дней(-я)
(2 отзывов(-а))