I'm not sure how this would help you. But this is something that one
of the far more advanced Excel users on this forum helped me with.

If you're using a formula that returns "#N/A," I typically try the
"iserror" route:

=if(iserror(your formula),0,your formula

0 being the value you want to show if true.

I'm not as sure about the lookup problem being that I usually just use
vlookup or hlookup. If you use one of those, I was told to write the
formula as:

=vlookup(lookup_reference,table array,column,0) --making sure to add
the 0 in the [range lookup] portion of the formula instead
disregarding it.

I did that last ttime and it returned seemingly random values.

Hi

I exported a trial balance into Excel. I am using the LOOKUP command to
pull amounts for general ledger codes into another summary worksheet, which
works fine. However if the LOOKUP command does not find the exact match, it
uses the next closest number to display, instead of displaying a zero

Other alternative formulas generate a #N/A when they do not find the exact
match, and that can also not be used in turn for other summary information

Any ideas on how I can get the exact numbers only for the general ledger
accounts ?