How to auto lookup data

[kimberly090]

I have my excel data like this in a workbook named :Customer_Information

I was looking for a formula that able to allow me to auto retrieve the rest of the detail when specific data is being insert.

Here will be my data inside my workbook, Customer_Information:

This will be the data in another workbook call PhoneBook:

I'm looking for a formula to auto retrieve the rest of the data when I type in the Name field.

For example when I type in Jack in B2, then on B3:B5 it will look for the data(Jack) in Customer_Information workbook and auto retrieve the data in the following field.

I was thinking to use VLOOKUP but it keep show me error.

Thank you.

 

[skorpionkz]

What version of the Excel to you have?

if 2007+ then use first formula otherwise second

Excel 2010
	A	B
1	Name	Result
2
3	Jack	2
Sheet2

Cell Formulas
Range	Formula
B2	=IFERROR(VLOOKUP(A2,Sheet3!$A$1:$B$24,2,0),"")
B3	=IF(ISERROR(VLOOKUP(A3,Sheet3!$A$1:$B$24,2,0)),"",VLOOKUP(A3,Sheet3!$A$1:$B$24,2,0))

 

[Aladin Akyurek]

Phone Book

B3, just enter and copy down:

=VLOOKUP(B$2,Customer_information!B:E,MATCH($A3,INDEX(Customer_information!B:E,1,0),0),0)

 

[kimberly090]

@@ I found my answer, I use : =VLOOKUP($B$2,Customer_information!$B$3:$E$7,2,FALSE)

 

[Aladin Akyurek]

@@ I found my answer, I use : =VLOOKUP($B$2,Customer_information!$B$3:$E$7,2,FALSE)

See post #3 for a formula you can copy down...

 

[kimberly090]

See post #3 for a formula you can copy down...

hi, it will not show if my first column contain date data ...

 

[Aladin Akyurek]

hi, it will not show if my first column contain date data ...

There is no date data in the images you posted...

See:
https://dl.dropboxusercontent.com/u/65698317/Kimberly090%20vlookup.xlsx