Hi Mantha,
Look at vLookup in Excel help.
Even better, see debra Dalgleish's tutorial at:
http://www.contextures.com/xlFunctions02.html
---
Regards,
Norman
"mantha09" wrote in message
...
please help
iwant to make a macro that consists of-
in Cell a1 my stock number
1541
in cell b1 my part name
crisps
when i enter my stock number i want my part name to appear.
is this possible??