IF function returning a #value error

[ids]

Hopefully some simple error here:

=IF(FIND("Y",test!AT8)<>0,test!B8,"NA")

Looking for this to return a blank cell if no "Y" in AT8, but getting #value.
Works fine and displays contents of B8 if "Y" is entered but cannot get the 'value if false' to display.
Can anyone see the mistake?

[:) Sixthsense :)]

=IF(ISNUMBER(FIND("Y",test!AT8)),test!B8,"")

[ids]

Totally solved Thanks Sixthsense

[:) Sixthsense :)]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.