macro help

[mantha09]

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

[Norman Jones]

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" <mantha09@discussions.microsoft.com> wrote in message
news:9301063A-2473-4A6D-B8C6-1B4E4A0A35B6@microsoft.com...
> 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??

[Roger Govier]

Hi

On Sheet2, set up a table of Stock numbers and Names starting in A2
A B
Stock No. Name
1541 Crisps
1843 Coca Cola etc.

Then on Sheet1 in cell B1
=VLOOKUP(A1,Sheet2!$A$2:$B$100,2,0)

Change the value of 100 in the above formula to include the last row of data
you have entered in your table on Sheet2.


Regards

Roger Govier


mantha09 wrote:
> 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??

[mantha09]

thank you, ill give it a go

"Norman Jones" wrote:

> 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" <mantha09@discussions.microsoft.com> wrote in message
> news:9301063A-2473-4A6D-B8C6-1B4E4A0A35B6@microsoft.com...
> > 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??
>
>
>