Lookup ID and between dates?

Hello everyone, hope someone can help me with this.

In a sheet called "data" I have a list of ID numbers, in column B (the length of this column could change, but is currently row 1 to row 12000, where row 1 has the column header).
In column K is a date.

The same ID number could appear multiple times in column B, but on each occassion there would be a different date in column k.

Here comes the difficult bit.
In another sheet, called "import" is a list of ID numbers in column B.
On the same sheet, in columns C and D are "to" and "from" dates.

What I want to be able to do is to look lookup the information from "data" and report back where the ID number appears in "import" and crucially where the data in column B of "data" is on or between the dates in column C and D of "import".

ANy help on how to do this would be really fantastic.
Thanks everyone.

I’m assuming you want a formula in E2 that will just give TRUE or FALSE, the ID in B2 appears in data worksheet with a date (or dates) between C2 and D2…..or not. Try this formula

=SUMPRODUCT(--(B2=data!B$2:B$12000),--(C2<=data!K$2:K$12000),--(D2>=data!K$2:K$120000))>0

copied down

Dear Carim and Daddylonglegs, many thanks for your replies, and especially to Carim for taking the time to respond to the zipped example, that works so well.
Thanks again.