LookUP from a List

Joe · Mar 28, 2004

I need to enter in any cell in Col C a code from a list
of codes on another worksheet.
Any help is appreciated.
Regards
Joe

Tom Ogilvy · Mar 28, 2004

Look in help at

Vlookup
Hlookup
Lookup

Index( Match())

Frank Kabel · Mar 28, 2004

Hi Joe
in addition to Tom's answer you may be looking for dat avalidation and
using a drop down list. See
http://www.contextures.com/xlDataVal01.html
for more details