lookup problem

Giganews Newsgroups
Subject: lookup problem
Posted by:  Todd Fischer (to…@fischerhome.net)
Date: Mon, 17 May 2004

I have a sheet with J11 called Buyers # and K11 called Buyers name. On the
next sheet called Buyers there is a list with B1 being the buyers number,
and C2 is the buyers names. How can I enter a number on the first sheet and
get the corresponding name to come up?