scareycarey
New Member
- Joined
- Apr 1, 2016
- Messages
- 10
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
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