Pulling The Date of the Most Recent Entry

I have a workbook that customer service uses to enter info on each time a store requests that we send them a box. We are having trouble with stores requesting boxes too frequently. They should only be requesting boxes every couple of months or so. I am attaching a simplified example of the workbook.

When customer service types the store number in column A, I need column C to pull in the most recent date they previously requested a box (or NA if they have never requested a box before)

The idea is that Customer Service can instantly see the last date sent by entering the store #.

This is my first post and I hope I am explaining this clearly. Also, thank you in advance for your help. Excel_Forum_Example.xlsx

The example I attached somehow changed. Please see this attachment.


Excel_Forum_Example.xlsx

Thank you for the reply.

Using the file you provided, I dragged the formula down like 10 cells in each column. I then entered a store number and it worked perfectly but would not do it for the next row down. Am I missing something?

Example of the error
2nd example.xlsx

Try ..

=IFERROR(VLOOKUP(A2-1,$A$2:$C$20,3,0),"N/A")

You need additional test if no date in C (is this likely?)

It works perfectly in the example but in the actual workbook I am trying to modify, there are non-numerical characters is the store # field. I probably should have included this in my original example.

Thank you again for all of your help. Side Note: My co-workers think it is really cool that someone from The Netherlands is helping me!

Example of the error
3rd example.xlsx

THis workbook is thousands of rows long and there may be several entries for the same store within the workbook. I only want it to pull the date from the most recent entry.

Eureka! Thank you for all of your help my friend. You probably earned me a raise in pay!