Match week and populate approve/reject text after each match row

[lumiance]

Dear Experts,

Can you please assist me with the following.
Attached an Excel file, the idea is that this file is an approval form per week.
This need to be signed by 2 persons via a button (approve or reject).
Now the part were i need assistance.
The last 2 columns should be populated by a text (approved/rejected) trough above button, but only the rows which match the week number.
I tried with index, match, offset but can't create a working code.
In attached file an example for Week 6 and how related fields should be populated once related button is pressed.
Can you please assist me?
Many Thanks
Lumiance

[lumiance]

I have created a working code.. thank you for viewed time!

Used code:

Please Login or Register  to view this content.