formula
 

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?:confused:


--
pinas
------------------------------------------------------------------------
pinas's Profile: http://www.excelforum.com/member.php...o&userid=32480
View this thread: http://www.excelforum.com/showthread...hreadid=522662

formula
 

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?:confused:


--
pinas
------------------------------------------------------------------------
pinas's Profile: http://www.excelforum.com/member.php...o&userid=32480
View this thread: http://www.excelforum.com/showthread...hreadid=522662

formula
 

thank you so much worked perfect:)


--
pinas
------------------------------------------------------------------------
pinas's Profile: http://www.excelforum.com/member.php...o&userid=32480
View this thread: http://www.excelforum.com/showthread...hreadid=522662