How can i use VLOOKUP in excel with equality condition?

Excel dataset

i want to change data layout by filtering the left table from redundancies i tried typing the below formula =IF(VLOOKUP(K8,$A$8:$E$82,5,FALSE)=$N$7,VLOOKUP(K8,$A$8:$E$82,4,FALSE),"na") it just works with the date 3/1/2021 but not for the rest of the columns for the rest of dates

anyone can help me with this problem? enter image description here