How to search if value 1 is with in a date range based on multiple other values?

[Uno707]

I'm really struggeling to figure out where to begin on a task I'm trying to solve.

Columns in current data set I've been attempting to work with;

Item | Item ID | Location | Date 

the problem statement:

"If Item is in Location A, and Location B, and the Date in Location A is less than any Date listed for Location B return True"

variables:

Each item can have mutliple dates

In plane text - If an Item in one location is expiring before the same item in another location flag this item.

Example: 

Item	Item ID	Location	Date	T/F
A	A-123	North	1/1/23	F
A	A-1234	South	1/15/23	T
A	A-12345	North	1/31/23	F
A	A-12346	South	2/15/23	F

Any ideas on how to search the range and return above results?