Searching for a name in one column for a value in another column - Help!?

[Cforrest]

Hi, all -

I'm posting this because I am doing an audit for work that is due (yesterday) and hoping someone can help me. I nneed to search for a name but return with the value in the next corresponding column. Can anyone help?

Here's an example.

SHEET ONE

A B C
Name Amount
Doe, John (***)

SHEET TWO
A B C
Doe, John
Doe, John
Doe, John 45
Smith, Jane
Smith, Jane 5
Smith, Jane

Sheet One - ***: This is where I would need the returned value. I want to search among multiple John Doe's in column A, but return with the value in column b. Only one value will be in column b per name, even though there may be multiples of John Doe in column A.

If I need to, I can go through and delete the duplicate names, so that I only search sheet 2 for the only John Doe and return with the value in that row.

Here's what I've tried: =VLOOKUP(A2,Sheet2!A$1:B$1140, 2, FALSE)

Obviously, it doesn't work or I wouldn't be posting on this forum.

Can anyone please help?

[zbor]

if Doe, John is in one cell try:

=SUMIF(Sheet2!A$1:A$1140, A2, Sheet2!B$1:B$1140)

[Cforrest]

Alright, I'm getting somewhere. But, it returned with a number that definitely does not correspond with the name that I'm look up.

Now what?? *

[zbor]

Now upload example workbook with your input and desired output.

(make sure to remove private data)

[Cforrest]

<<<embarrassed>>>

How do I upload to this forum?

[Cforrest]

file:///C:/Documents%20and%20Setting...el%20Forum.htm

[zbor]

click edit -> Go advanced and then click "paper clip" icon and browse file to your computer.

[Cforrest]

Ok, I think I got it.

Thanks!

[zbor]

So what's wrong with:

=SUMIF(Sheet2!$A$2:$A$1000, $A2, Sheet2!B$2:B$1000) in B2 of Sheet1?

it will return SUM of all doe,john it find in second sheet.

[Cforrest]

Actually, I have no clue. When I applied it to the file I need, it came up with a very large number that I was not familiar with.

But, I did see in the first suggestion you did not have $A2, but you do now. I'll try that really quick.

[Cforrest]

yep! not having $A2 was the problem. It works! Holy cow - I could cry!! Thank you, thank you!!

Now, on to the rest of the document. Hopefully I won't have to post again later. Yikes!

[zbor]

Feel free to post again

[Cforrest]

Thank you for your help. That has to be so hard to understand when someone is trying to explain. I should have uploaded a sample from the beginning. You did such an amazing job being patient and understanding - THANK YOU!!!!!!!!