Autofill of cells.

[imported_unknown]

I apologize in advance if this has already been answered. Is there a way to autofill a cell? I.E. If I type in a employee number(Say...C5) another cell(B5) will display their name?


Thank you in advance.

 

[PaddyD]

Hi - welcome to the board!

sounds like you need the vlookup() function - chack it out in the help file & search this board for examples. Post back with more info on what you're trying to do if you need...

Paddy

 

[Brian from Maui]

Silverae

I'm on lunch Paddy so I thought I'd do a simple one

Book1
	A	B	C	D
1	2323	Joe	Goalie
2	EmpNo	Name	Position
3
4	1331	John	Sweepr
5	3131	Chris	Forward
6	2323	Joe	Goalie
7	4356	Kurt	Striker
Sheet1

"List" is the named range of A4:C7
A1 is the lookup cell, where you enter unique data
2 and/or 3 is the column to return the info
And 0 or False meaning find an exact match