Having a hard time understanding how your question related to that 'sum' you've described...

Are you looking for that same 'sum' in a table that contains various possible 'sums' in column A? I'm assuming there's a column 'B' that contains some values you want to return once you've found that item in column 'A'.

What's throwing me off here though is your use of the word 'name' in the last line of your message. But I'm going to assume you mean 'sum' otherwise you're going to have to clarify - or post the sheet.

Anyhow, if this is the case (ie. looking for a 'sum'), it's a simple enough task. Let's assume you're storing what you want to find in cell "BZ1" (based on your sum formula, I'm just guessing here). Let's say you have 200 possible values of this listed in column A of sheet2. Just pick a cell say "G1" in sheet2 and type:
=VLOOKUP(sheet1!BZ1,A1:B200,2)
If excel finds that sum in your table, it'll then return in G1 the value of the contents of column B (column "2" of that array) right next door to that value.

There are some other optional parameters for VLOOKUP, for example if you are looking for an exact match vs. just 'something close'.

Let me know if this helps. Feel free to contact directly - elliot_bendoly@bus.emor.edu

Dr. Elliot Bendoly
Emory University
www.bizbreed.com