Locate a number in a named range and return date in the adjoining cell.

I need to find out when a "filing_batch" was created.  
In the attachment, I need to insert a date in column F based on the filing_batch number in column E.  The table that contains the anser is on worksheet2.

So, for rows 2 through rows 323, the date that should be returned is 2/1/2014, etc.
Who is Participating?
barry houdiniConnect With a Mentor Commented:
Try this formula in F2 copied down


see attached

regards, barry
If you can sort your worksheet2 on column A, you can use this:

Is this what you are looking for?
klitton7Author Commented:
I didn't word my question properly it seems...

Every row on Worksheet1 that has data should have a date in column F.  There should be dates all the way through row 6655

So worksheet1,  F22 should return date 2/1/2014 because the filing_batch number 39009 falls inbetween the range of numbers A2-B2 on Worksheet2.

Actually 2/1/2014 would post all the way through row 323.  Then 2/3/2014 will post from row 324 through 1389, etc.
klitton7Author Commented:
Perfect!  Thanks Barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.