Lopping through a range

[Takes2ToTango]

Hi All,

I need to do the following but can't figure out how to do so.

I have a target number which is 12. I need to go through each row of a table and wherever the target number is, I need to grab the value in the Range column and then create a new list to the right.

AS the example above. The target is 12. We cycle through the table and where there is a 12 we pull out the Range letter and add it to our list on the right. So A and Z are both taken.

Hopefully this makes sense to someone.

Many thanks

 

[hagia_sofia]

Do you mean something like:

=FILTER(B2:B8,A2:A8=D2)

 

[Takes2ToTango]

Do you mean something like:

=FILTER(B2:B8,A2:A8=D2)

That works perfectly, I knew it would be something simple! Many thanks to you