IF(C:C,B1,.... display column A:A) - so frustrated

[NomadWithaPC]

I've been so frustrated trying to find an answer.

I'm trying to get the text in the corresponding cell in column A to display when column C matches the number in B1.

I feel like there's something simple I'm overlooking. Any help (even condescending ) would be much appreciated.

 

[Eric W]

Maybe:

=IF(C2=$B$1,A2,"")

 

[Marcelo Branco]

Maybe...

=INDEX(A:A,MATCH(B$1,C:C,0))

M.

 

[NomadWithaPC]

Maybe:

=IF(C2=$B$1,A2,"")

This worked for the first cell but that was it. The remaining cells display nothing ("").

This is what I have in column D:

=IF(C:C=$B$1,A:A,"")

Each cell in column D references a different tab, but outside of the tab reference, the formula remains the same.

 

[NomadWithaPC]

Maybe...

=INDEX(A:A,MATCH(B$1,C:C,0))

M.

This works like a charm... awesome, thank you both so much!!!!