VLOOKUP: Can someone do the function for me please?

[Guest]

What I have is an invoice for a scrapbooking company on the 1st page, and I
have all of the stock with item #'s, description and price on the 2nd sheet.
I want to be able to type in an item # on the invoice and have the #,
description and price come up automatically.

Someone tried to tell me how to do this, I am totally not understanding what
they told me.

If you know how to do this, I will email you my spread sheet, if you are
willing to put the functions in for me. (I do have other funtions put in the
invoice already)

Thank you for any help.
Jaci

 

[T. Valko]

Suppose you have this table on Sheet2:

..............A......................B....................C
1.........Item #..........Description..........Price
2..........1..................Book................13.99
3..........2..................Paper..................5.99
4..........3..................Pen.....................1.29
5..........4..................Binder.................3.99
6..........5..................Pencil..................0.59

On Sheet1 you have these headers in A1:C1 -

..............A......................B....................C
1.........Item #..........Description..........Price
2...............................................................

Enter this formula in Sheet1 cell B2:

=IF(COUNTIF(Sheet2!$A2:$A6,$A2),VLOOKUP($A2,Sheet2!$A2:$C6,COLUMNS($A:B),0),"")

Copy across to C2

Now, if you enter an item number in Sheet1 cell A2 the description and price
will automatically fill in.

Biff

 

[Guest]

I have sent you an email.

Suppose you have this table on Sheet2:

..............A......................B....................C
1.........Item #..........Description..........Price
2..........1..................Book................13.99
3..........2..................Paper..................5.99
4..........3..................Pen.....................1.29
5..........4..................Binder.................3.99
6..........5..................Pencil..................0.59

On Sheet1 you have these headers in A1:C1 -

..............A......................B....................C
1.........Item #..........Description..........Price
2...............................................................

Enter this formula in Sheet1 cell B2:

=IF(COUNTIF(Sheet2!$A2:$A6,$A2),VLOOKUP($A2,Sheet2!$A2:$C6,COLUMNS($A:B),0),"")

Copy across to C2

Now, if you enter an item number in Sheet1 cell A2 the description and price
will automatically fill in.

Biff

 

[Guest]

Thank you for your reply, I tried to email you, but it cam back.

I don't know what my problem is..but I am
having such a hard time understanding this function. Could I please send
you my invoice and have you insert the function for me? I know that is
asking a lot, if it would be a problem I understand. If you want to
charge me for doing this, let me know how much it would be.

I have 1,276 stock items listed and I guess I am just not real sure
what numbers to change, and if I need to change how I have the cells set
up on the actual invoice for the #, description and price to show up.
If I should change that from 3 cells to 1 cell.

Thank you for being patient with me, I know some functions in excel,
but this is something new I am TRYING (not very successfully) to learn.

 

[T. Valko]

Post your email address and I'll contact you. Just make sure you disguise it
like:

me<at>someplace<nospam>dotcom

Biff

 

[Guest]

Thank you so much!!!
jacischildcare<at>yahoo<nospam>dotcom