Hasty help needed with excel formula.

[asim18]

Basically I have one sheet with the following columns:

Customer ID | Customer Name


And another sheet with:

Customer ID | Customer Name


I want to make it so that I fill in everything in the first sheet, but then when I enter a "Customer ID" in the second sheet, it automatically fetches the "Name" from the first sheet for the corresponding ID.

So for example, if i have a record "0001 | John" in the first sheet, i want it so that when I enter "0001" in the second sheet, it automatically fetches "John" and enters it in the second column

My teacher said we have to use vlookup i think, but he never taught us anything else and I don't know how to implement it.


Thank you for any assistance.

 

[Dolph]

Assuming that the details are in sheet one columns a and b, and the lookup in sheet 2 columns a and b.

In sheet 2 column be you need the following formula

=vlookup(a1, Sheet1!A:B, 2, false)

http://office.microsoft.com/en-us/excel/HP052093351033.aspx

Copy this formula down each cell, obviously updating a1 to reflect the cell containing the customer ID for that row.

 

[asim18]

Thanks for the quick response!

Will try it now.

 

[Pho]

Here's a demo of what you need

+ http://office.microsoft.com/en-us/excel/HP052093351033.aspx

edit: beat

 

[asim18]

Oh man, you guys are awesome. If only my teacher was as wise as you.

(It's the same idiot teacher that thinks hard drive motors are 100% energy efficient and produce NO sound or heat whatsoever)

 

[asim18]

One more question: What does "false" do in the formula?

 

[MarcLister]

False tells Excel to look for an exact match. Setting it to true or leaving it out altogether permits Excel to look for the closest match.

 

[asim18]

Thanks mate.