I do almost all of my coding in VBA, not Excel, so this one is new to
me...

I have an external lookup plug-in (BBG) that returns "#N/A" if the
lookup fails. I have populated a column in my sheet with these
formulas, some of which return #N/A, and others that return numbers. I
would like to make a formula that uses the number if it's there, and
ignores it if it's #N/A.

In code I would simply refer do this:

Left(Range(A1).text,1) < "#"

But how do I do this in an XL formula?

Maury