If statement to return list of values based on 1 criteria

[ialexander03]

Hi All,

My issue is probably simple, but Im in a brain fog!

I have 2 columns, in A, I have a list of lesson numbers, and in B a list of unique subject IDs.
Example

1	1.1
1	1.2
1	1.3
2	1.4
2	1.5
3	1.6
3	1.7
1	1.8
1	1.9
2	1.10

What I want to do is return only those subject IDs for a specific lesson.

So example, on a second tab,

A1 = dropdown for lesson numbers

B1 - B10 = returned lesson IDs

I have tried to find the answer, but every time I do it, it only returns the first hit, so for Lesson 1, Subject 1.1. If I drag down the forumla for 5 cells, expecting to see 1.1, 1.2, 1.3, 1.8 & 1.9, I just get 5 x 1.1.

Please help!!!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ialexander03]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Hi, using O365

 

[Peter_SSs]

Hi, using O365

Please add it to your profile as suggested by @Fluff so the information is always readily available to helpers.

Is this what you want?

24 02 22.xlsm
	A	B	C	D	E	F
1	2	1.4			Example
2		1.5			1	1.1
3		1.1			1	1.2
4					1	1.3
5					2	1.4
6					2	1.5
7					3	1.6
8					3	1.7
9					1	1.8
10					1	1.9
11					2	1.1
IDs

Cell Formulas
Range	Formula
B1:B3	B1	=FILTER(F2:F11,E2:E11=A1)
Dynamic array formulas.