formula

[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?

[Tom Ogilvy]

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

[pinas]

thank you so much worked perfect