Finding End Week Dates Using Vlookups Within Date Ranges

I'm trying to find the week end date using fridays as the end of the week from a list that has the actual date work was done for items 1-12. The dates need to be with in the range specified at the top. Basically if the actual dates for work done for items 1-12 from the date table below fall into the specified range, the friday end date of that week the work was done would appear in the table above and everything outside the range would remain blank. I've attached an very basic example. I imagine i would need to use some sort of Vlookup that looked at the table below to match the item number to the date and then if that date fell into the data range it would change the date to the friday of that week.

That definitely works for the example shown so thank you, but I left out some detail. The table down below is actually going to be coming from another workbook where the item numbers are not going to be in order as they are in my example. I'm basically going to need the formula to do a check (like a vlookup) against the item#s before it does the other formulas.

Thanks daddy, I figured it out using the format you gave me and inserting a vlookup function into it. here is the formula if anyone is interested.

=IF(AND(VLOOKUP($A8,$A$23:$C$34,2,FALSE)>=$D$2,VLOOKUP($A8,$A$23:$C$34,2,FALSE)<=$D$3),VLOOKUP($A8,$A$23:$C$34,2,FALSE)+7-WEEKDAY(VLOOKUP($A8,$A$23:$C$34,2,FALSE)+1),"")