Finding the closest value to a given cell within a column, matching 2 variables (a date and an item part number)

[Vermilion]

Hello, I am using Excel 2010 and I have this issue:

I have an inventory table where I register the entry of products.
Every time there is an entry of product, I should register its part number, the date of the entry, and the most recent day before the current entry.

Therefore, I am looking for a formula that automatically allows me to identify the closest date before the current entry of data I mentioned; however, it should only look within the dates that correspond to the item in the row.

Something like this:

Item	Date	Result
X	January-01-01	January-01-01
Y	February-01-01	February-01-01
Z	March-01-01	March-01-01
X	October-01-01	July-01-01
X	July-01-01	January-01-01

<tbody>
</tbody>

Then, I want to know the position of the cell which contains my result:

Item	Date	Result
X	January-01-01	B1
Y	February-01-01	B2
Z	March-01-01	B3
X	October-01-01	B5
X	July-01-01	B1

<tbody>
</tbody>

And finally, I want to change the column (for example to column F):

Item	Date	Result
X	January-01-01	F1
Y	February-01-01	F2
Z	March-01-01	F3
X	October-01-01	F5
X	July-01-01	F1

<tbody>
</tbody>

PD. I cannot use a macro, because that function is blocked per company policy.

Any ideas?
Thank you!