Try this:-

=IF(ISNA(VLOOKUP(C1,A1:B100,2,FALSE)),"",VLOOKUP(C 1,A1:B100,2,FALSE))

Uses table A1:B100 to find an exact match only in column 2 for the criteria
in C1.

Mike

"Jason" wrote:

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 ?