Look in Excel VBA help at the Vlookup formula
=if(A1="","",vlookup(A1,mastersheet!$A$1:$B$2000,2 ,false))
--
Regards,
Tom Ogilvy
"pinas" wrote:
I have a master parts list and am needing to create a formula that will
allow me to enter a part number on a different sheet and the
description of the part will automatically appear any
suggestions?
--
pinas
------------------------------------------------------------------------
pinas's Profile: http://www.excelforum.com/member.php...o&userid=32480
View this thread: http://www.excelforum.com/showthread...hreadid=522662