if match enter info in another cell

[SDKBRK]

I want to know how to enter a formula or what formula do I use.

I have database and in the first column is the FILE#, 2nd column CITY, 3rd column DRIVERS NAME.

This is what I need as a formula.

In a different worksheet in cell A1 I type the FILE#, in cell B2 I want a formula that will lookup the FILE# and put the DRIVERS NAME that matches the FILE# that is in my database.

EXAMPLE DATABASE
A B C
1 File # DESTINATION EMPLOYEE NAME
2 001 Murfeesboro, TN Dana Jeanes
3 002 Nashville, TN Jack Salmon
4 003 Murfeesboro, TN Steve Ledford


This is the other worksheet. Need the formula in

driver name: formula
file number: 001


Thanks

 

[MrKowz]

This is a perfect candidate for VLOOKUP:

=VLOOKUP(A1,Sheet1!A1:C100,3,FALSE)

Assuming that your database is in a sheet named "Sheet1". Adjust the lookup range as needed.

 

[jim may]

Excel Workbook
	A	B	C
1	File #	DESTINATION	EMPLOYEE NAME
2	001	Murfeesboro, TN	Dana Jeanes
3	002	Nashville, TN	Jack Salmon
4	003	Murfeesboro, TN	Steve Ledford
Sheet1

Excel 2007

Excel Workbook
	A	B
1	002
2		Jack Salmon
Sheet2

Excel 2007

Cell Formulas
Range	Formula
B2	=VLOOKUP(A1,Sheet1!$A$2:$C$4,3,FALSE)

 

[hiker95]

SDKBRK,

Something like this?

Excel Workbook
	A	B	C
1	File #	DESTINATION	EMPLOYEE NAME
2	001	Murfeesboro, TN	Dana Jeanes
3	002	Nashville, TN	Jack Salmon
4	003	Murfeesboro, TN	Steve Ledford
5
DATABASE

Excel Workbook
	A
1	001
2	Dana Jeanes
3
Search

 

[SDKBRK]

Thank you so much. I have never used that formula. It works like a charm.

Thanks guys.

di