formula - Xlookup/Vlookup

[GeorgeTimes]

Hi all,

I'm trying to write a formula in order to look for 2 items in a Pivot Table.
My table has 2 column:
1- Country (i.e UK, Spain, France etc.)
2- Company name

For every new week I have a new Pivot Table and what I'm trying to do is search if Company X (CocaCola for example) within Country Y (UK for example) from this week data was in that first week Pivot Table.

My issue: If first week I have for example Coca Cola in UK, and now in the second week I have Coca Cola in Spain, what I want to do is search if Coca Cola in Spain appeared in the first week.

At the moment I don't know how to search for both "Coca Cola" and "Spain" within a PivotTable. I've tried Xlookup however I get the return as affirmative as I only check for the word "Coca Cola"

Any idea what kind of formula I need in order to be able to search for both words?

example.xlsx
	B	C
20	Row Labels	Sum of Total 90+ EUR
21	UK	8876.3264
22	Company B	-343.7656
23	Coca Cola	9220.092
24	Ireland
25	Company C
26	Spain
27	Company D
28	France	255450.15
29	Company E	255450.15
30	Grand Total	264326.4764
Table

 

[awoohaw]

Is the source data from the same table? If so, is the date in that source data? If so, use a Pivot FIlter.
IF So, like this (My pivot layout is different, but I hope you understand, it is the filter at the top):

Some Mr Excel Questions.xlsx
	B	C	D	E	F	G	H	I	J
1
2							DATE	1/1/2023
3							PRODUCT	PEPSI COLA
4		DATE	COUNTRY	PRODUCT	SALES
5		1/1/2023	UK	COCA COLA	166		COUNTRY	Sum of SALES
6		12/1/2022	SPAIN	PEPSI COLA	200		UK	64
7		1/1/2023	FRANCE	SPRITE	93		Grand Total	64
8		12/1/2022	UK	PEPSI COLA	122
9		1/1/2023	SPAIN	SPRITE	99
10		12/1/2022	FRANCE	COCA COLA	93
11		1/1/2023	UK	PEPSI COLA	64
12		12/1/2022	SPAIN	PEPSI COLA	98
13		1/1/2023	FRANCE	SPRITE	141
14		12/1/2022	UK	PEPSI COLA	126
15
Sheet5