vlook up help and maybe if function as well

Hi
I looking for some help solving this formula if someone could help I would be grateful

I have used this but does not work =IF($B3=$D$2,VLOOKUP($B3,B:C,2,),FALSE) I just keep getting the same name

The below is an example of what I am looking for
if there is a 1 in table 1 column B (week) then put that name in sheet 1 column E ( there may be multiple "1"s in table 1 with different names

TABLE 1
A B C
1 Week NAME
2
3 01 AB
4 21 AC
6 18 AD
7 13 AE
8 01 AF
9 19 AG
10 27 AH
11 01 AI
12 05 AJ
13 31 AK


Sheet 1
D E
1 1 AB
2 AF
3 AI
4


Kind Regards

Richard Info.docx

Hi,

An actual workbook in which you've added the results you expect would be most useful. These things are always easier of we can see the request in context. That said have you considered a simple Pivot Table?

Hi,

Please upload the workbook not just a picture of it. We much prefer to work with real data and avoid spending time recreating something you already have.