Formula help vlookup and possibly if

[scareycarey]

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

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​
1​	Week	NAME		week
2​				1​
3​	1​	AB		count
4​	21​	AC		3​
5​	18​	AD		LIST
6​	13​	AE		AB
7​	1​	AF		AF
8​	19​	AG		AI
9​	27​	AH
10​	1​	AI
11​	5​	AJ
12​	31​	AK

In D4 just enter:

=COUNTIFS($A:$A,D$2)

In D6 control+shift+enter, not just enter, and copy down:

=IF(ROWS($D$6:D6)<=D$4,INDEX($B$3:$B$12,SMALL(IF($A$3:$A$12=D$2,
    ROW($B$3:$B$12)-ROW($B$3)+1),ROWS($D$6:D6))),"")

 

[scareycarey]

Hi
I cannot seem to get this to work any other ideas please

 

[Aladin Akyurek]

Hi
I cannot seem to get this to work any other ideas please

Any other ideas? The information you provide is not sufficient to go on, but perhaps you did not apply control+shift+enter properly:

Control+shift+enter >> Press down the shift and the control keys at the same time while you hit the enter key. If done properly, Excel itself puts a pair of { and } around the formula.

 

[scareycarey]

I have managed to sort now and all works perfectly. Thank you very much for your help Aladin much appreciated

 

[Aladin Akyurek]

I have managed to sort now and all works perfectly. Thank you very much for your help Aladin much appreciated

You are welcome. Thanks for the update.