Hello friends
I have a database with a date column, the customer's name in the header - when that column has values and the country of that customer,
At the bottom of the sheet there is a small database with date, country and value and I am interested in returning the customer name - in the sheet I attached I am interested in finding the cell range: H16: H22
Attach you a sample sheet - hope I was clear:
I have a database with a date column, the customer's name in the header - when that column has values and the country of that customer,
At the bottom of the sheet there is a small database with date, country and value and I am interested in returning the customer name - in the sheet I attached I am interested in finding the cell range: H16: H22
Attach you a sample sheet - hope I was clear:
Data.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Date | client 1 | Country | client 2 | Country | client 3 | Country | client 4 | Country | client 5 | Country | client 6 | Country | ||
2 | 06/10/2021 | 78 | Italy | 4 | Germany | 11 | Netherlands | 5 | Germany | 99 | Italy | 17 | Argentina | ||
3 | 07/10/2021 | 78 | Italy | 4 | Germany | 11 | Netherlands | 5 | Germany | 99 | Italy | 17 | Argentina | ||
4 | 13/10/2021 | 78 | Italy | 4 | Germany | 11 | Netherlands | 5 | Germany | 99 | Italy | 17 | Argentina | ||
5 | 14/10/2021 | 78 | Italy | 4 | Germany | 11 | Peru | 3 | Germany | 99 | Italy | 17 | Argentina | ||
6 | 20/10/2021 | 80 | Italy | 4 | Argentina | 11 | Peru | 3 | Germany | 99 | Italy | 17 | Argentina | ||
7 | 21/10/2021 | 80 | Italy | 4 | Argentina | 12 | Peru | 3 | Germany | 99 | Netherlands | 17 | New Zealand | ||
8 | 27/10/2021 | 80 | Italy | 4 | Argentina | 12 | Peru | 3 | Argentina | 99 | Netherlands | 17 | New Zealand | ||
9 | 28/10/2021 | 78 | Germany | 4 | Argentina | 12 | Peru | 3 | Argentina | 54 | Netherlands | 17 | New Zealand | ||
10 | 03/11/2021 | 78 | Germany | 4 | Argentina | 12 | Peru | 3 | Argentina | 54 | Netherlands | 17 | New Zealand | ||
11 | 04/11/2021 | 78 | Germany | 4 | Argentina | 12 | Peru | 3 | Argentina | 54 | Netherlands | 17 | New Zealand | ||
12 | |||||||||||||||
13 | |||||||||||||||
14 | |||||||||||||||
15 | Date | Country | No. | Client | |||||||||||
16 | 21/10/2021 | Germany | 3 | client 4 | |||||||||||
17 | 21/10/2021 | Netherlands | 99 | client 5 | |||||||||||
18 | 28/10/2021 | New Zealand | 17 | client 6 | |||||||||||
19 | 03/11/2021 | Argentina | 3 | client 4 | |||||||||||
20 | 21/10/2021 | Italy | 80 | client 1 | |||||||||||
21 | 07/10/2021 | Netherlands | 11 | client 3 | |||||||||||
22 | 14/10/2021 | Germany | 4 | client 2 | |||||||||||
Data |