Formula to apply sequential value - based on category and ordered by date

[ExcelVictoria]

Hello,

I would appreciate your help with the formula or VBA code for the following function.

In the 'Used/unused item number' column I need to apply a sequence of numbers.

If the item in the 'Used/Unused' column is 'Used' the formula should by order of 'Date' apply the sequence from the location 'Data entry'!I1:I300. This looks for example as follows:

E1

E2

E3

E4

E5

If the item in the 'Used/Unused' column is 'Unused' the formula should by order of 'Date' apply the sequence from the location 'Data entry'!H1:H300. This looks for example as follows:

UM1

UM2

UM3

UM4

UM5

Item

Date

Used/Unused

Used/unused item number

Sensitive

Sensitive item number

Exhibited

Exhibited by

RP

File type

Location

Redaction

Clipping

Power (if applicable)

Continuity

Description

Example 1

06/11/2022​

Unused

No

N/A

Example person

Yes

Niche word

Niche occ reports

With ASAs

N/A

N/A

N/A

Example 2

07/11/2022​

Used

Yes

Yes

Example person

Yes

PDF

Niche case file

Redacted

N/A

N/A

N/A

Example 3

05/11/2022​

Unused

No

N/A

Example person

No

Video

NICE

N/A

N/A

N/A

N/A

Finally, in the 'Sensitive item number' column I need to apply a sequence of numbers.
If the item in the 'Sensitive' column is 'Yes' the formula should by order of 'Date' apply the sequence from the location 'Data entry'!J1:J300. This looks for example as follows:

S1

S2

S3

S4

S5

Many thanks in advance for your help! Much appreciated