Take a look at the VLOOKUP function

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Confused in Virginia" <Confused in
wrote in message ...
I am creating a "parts" list, gives part number, discription, and cost,
from
a particular vendor, I would like to know if i can just enter the part
number
and the rest of the cells will fill themselves in automaticlly.