Modify MATCH formula to return true or false

[suprsnipes]

Hi,

I am using the following formula but I'm not quite sure how to modify it to achieve what I want.

=MATCH($F5,fxhigh!$D$2:$D$50,0)

It works but instead of returning a value or #N/A I would like to assign true or false instead.

How could I do that?

 

[VoG]

Try

=ISNUMBER(MATCH($F5,fxhigh!$D$2:$D$50,0))

 

[suprsnipes]

That's great, thanks. One last question how can you assign your own values other than true or false for this formula?

 

[VoG]

Try like this

=IF(ISNUMBER(MATCH($F5,fxhigh!$D$2:$D$50,0)),"Yes","No")

 

[suprsnipes]

Appreciate your help