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

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?

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?? *

<<<embarrassed>>>

How do I upload to this forum?

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

Ok, I think I got it.

Thanks!

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.

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!

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!!!!!!!!