Please see the sheet and help me

[Saroj Kumar]

C:\Users\Saroj_Kumar\Desktop\Sample

 

[Luke M]

The start dates in table 1 do not always match dates in table 3. What should happen in those instances?

 

[Saroj Kumar]

In that case cell would be blank

 

[Luke M]

See attached.

 

[Saroj Kumar]

No No. I think u haven't got what I want. Quest already mentioned on that sheet.
Find out the Activity ID from 3rd table by Matching ProjectId and Date range (Date which is between Start date and end date) from 1st table.

 

[Luke M]

Ah. That is a better answer to my first question. We will then use some boundaries, rather than an exact match.

 

[Saroj Kumar]

Thanks! Perfect