Filter Function return another col in a table

[ManUBlueJay]

I would like to return the 3rd column of a table, filtered by the 1st column where all values in the 1st Column are equal to A1

 

[etaf]

are you still using 2016 - FILTER() function is not available on that version
please update profile

=FILTER(C:C, A:A=$A$1)
OR if you mean the text "A1" and NOT cell
=FILTER(C:C, A:A="A1")

i would prefer to use row reference

 

[ManUBlueJay]

First one works. Thank you

 

[etaf]

you are welcome
you need to update your profile , solutions will depend on what version of excel -

 

[ManUBlueJay]

cheers for that

 

[etaf]

as you are showing 2 versions of excel - when you ask a question, you will need to say what version you want this to work
there are 100's of new functions since 2016 -

 

[ManUBlueJay]

Sorry I undid but didnt save it. Fixed now

 

[etaf]

thanks

 

[ManUBlueJay]

One more quick quesion regarding filter, which I have in another scenario.
=FILTER(C:C, A:A="A1") but exclude any that appear in B:B

 

[etaf]

=FILTER(C:C, (A:A="A1")*(B:B<>"A1"))