Vlookup with a Y answer

[EdieB]

I have been charged with coming up with a spreadsheet that will show if someone attended a function each week. I have set up one tab (Weekly Attendees) to include the names and the dates attended. I would like another tab (Attendance) to have the names in Col. A with the Dates on line 1 for 52 columns. I would like the result to be Y when the person attends based on the date from the Weekly Attendee Tab. I know how to use Vlookup and Sumif, but I can't figure out how to get a Y (or blank if they didn't attend) if they attend on a specific date.

Can someone help?

 

[EdieB]

Joe, thank you so much. I knew about locking down the formulas or anchoring as an instructor I had once called them. I just didn't in my example. But, I was getting "value" until I copied what you sent into the cells.

Again, thanks so much. My Pastor is going to be so happy.

 

[Joe4]

You are welcome!
Glad I was able to help you get your problem solved.