Hey guys,

I have been trying to figure out why my Excel formula is not working, but can't seem to figure it out.

The web has a lot of information regarding ISNA, but when I use it the formula seems to be broken or something.

I have the following formula in D4 of Sheet1:

For some reason whether the phone number matches or not it still shows the answer "No" for both cases.

Callers1 is a named range for Column A2:A100 on Sheet2 which only contains phone numbers.

D3 represents the cell used to input the telephone number

on Sheet1 (ex: 813-744-4309 [spam number by the way. lol]).

My goal is to have it check for a phone number. If it is there then it says yes in D4. If it doesn't find the phone number the it says No in D4.

Thanks in advance

Ty

I have been trying to figure out why my Excel formula is not working, but can't seem to figure it out.

The web has a lot of information regarding ISNA, but when I use it the formula seems to be broken or something.

I have the following formula in D4 of Sheet1:

Code:

`=IF(ISNA(MATCH(D3, Callers1, 0)), "No", "Yes")`

Callers1 is a named range for Column A2:A100 on Sheet2 which only contains phone numbers.

D3 represents the cell used to input the telephone number

on Sheet1 (ex: 813-744-4309 [spam number by the way. lol]).

My goal is to have it check for a phone number. If it is there then it says yes in D4. If it doesn't find the phone number the it says No in D4.

Thanks in advance

Ty

Last edited: