=IF(MATCH(B2,A:A,0),$F:$F)

Hi everyone,

Here's what I'm trying to do:

I want to take a phone number given in B2 and find its match in A:A, printing the F value that corresponds with the match in A. The match formula returns row # "2049", but my IF function returns F2 instead of F2049.

If this makes sense, I would appreciate some thoughts on how to print F(match value)