formula

P

pinas

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:
 
T

Tom Ogilvy

Look in Excel VBA help at the Vlookup formula

=if(A1="","",vlookup(A1,mastersheet!$A$1:$B$2000,2,false))
 
Top