Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 09, 03:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 2
Default Product Code and Product Description setup

Hello. I have a worksheet that contains one column for Product codes and the
second coloum contains the product description.

How can I set up a system in another worksheet whereby if the product code
is entered into one cell, the corresponding product description is
automatically entered into the cell next to it?

Thank you

  #2   Report Post  
Old July 6th 09, 03:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default Product Code and Product Description setup

Hi,
Let's say you have the product code in column A starting in row 2 in sheet 1
and the description in column B, then you want in sheet 2 to populate the
description when product code is entered in cell A3, so in cell B3 in sheet 2
enter

=sumproduct(--(A3=sheet1!$A$1:$A$100),sheet1!$B$1:$B$100)

adjust range to fit you needs but remember the range has to be the same in
both sides of the formula

if you are using excell 2007 use

=sumproduct(--(A3=sheet1!A:A),sheet1!B:B)


"Nastyashman" wrote:

Hello. I have a worksheet that contains one column for Product codes and the
second coloum contains the product description.

How can I set up a system in another worksheet whereby if the product code
is entered into one cell, the corresponding product description is
automatically entered into the cell next to it?

Thank you

  #3   Report Post  
Old July 6th 09, 05:22 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 2
Default Product Code and Product Description setup

I'm not sure if I'm doing it right but it does not appear to be working. I
have Excel 2003.

Apparently this has something to do with the 'Lookup' function. I'm not
sure.??

Thanks


"Eduardo" wrote:

Hi,
Let's say you have the product code in column A starting in row 2 in sheet 1
and the description in column B, then you want in sheet 2 to populate the
description when product code is entered in cell A3, so in cell B3 in sheet 2
enter

=sumproduct(--(A3=sheet1!$A$1:$A$100),sheet1!$B$1:$B$100)

adjust range to fit you needs but remember the range has to be the same in
both sides of the formula

if you are using excell 2007 use

=sumproduct(--(A3=sheet1!A:A),sheet1!B:B)


"Nastyashman" wrote:

Hello. I have a worksheet that contains one column for Product codes and the
second coloum contains the product description.

How can I set up a system in another worksheet whereby if the product code
is entered into one cell, the corresponding product description is
automatically entered into the cell next to it?

Thank you

  #4   Report Post  
Old July 6th 09, 05:31 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Product Code and Product Description setup

With Product code and description in ColA and ColB of Sheet2

In sheet1 A1 enter a sample product code
In Sheet1 B1 enter the below formula which will lookup the list of codes in
Sheet2 and retrive the product description aganist the code...
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

--
If this post helps click Yes
---------------
Jacob Skaria


"Nastyashman" wrote:

Hello. I have a worksheet that contains one column for Product codes and the
second coloum contains the product description.

How can I set up a system in another worksheet whereby if the product code
is entered into one cell, the corresponding product description is
automatically entered into the cell next to it?

Thank you

  #5   Report Post  
Old July 6th 09, 05:48 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default Product Code and Product Description setup

Hi,
use

=VLOOKUP(A3,Sheet1!A:B,2,FALSE)

"Nastyashman" wrote:

I'm not sure if I'm doing it right but it does not appear to be working. I
have Excel 2003.

Apparently this has something to do with the 'Lookup' function. I'm not
sure.??

Thanks


"Eduardo" wrote:

Hi,
Let's say you have the product code in column A starting in row 2 in sheet 1
and the description in column B, then you want in sheet 2 to populate the
description when product code is entered in cell A3, so in cell B3 in sheet 2
enter

=sumproduct(--(A3=sheet1!$A$1:$A$100),sheet1!$B$1:$B$100)

adjust range to fit you needs but remember the range has to be the same in
both sides of the formula

if you are using excell 2007 use

=sumproduct(--(A3=sheet1!A:A),sheet1!B:B)


"Nastyashman" wrote:

Hello. I have a worksheet that contains one column for Product codes and the
second coloum contains the product description.

How can I set up a system in another worksheet whereby if the product code
is entered into one cell, the corresponding product description is
automatically entered into the cell next to it?

Thank you



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need a product key for my Trail product, 2007 Microsoft Office s sltchsyi Setting up and Configuration of Excel 0 May 4th 09 01:32 AM
How Can I Assign an Specific Code to every Product Gmata Excel Discussion (Misc queries) 5 December 31st 07 08:21 PM
where is the product code for operating cd jojo Setting up and Configuration of Excel 0 December 25th 05 04:26 PM
Capture first 2 letters from a product code stumped Excel Worksheet Functions 2 May 18th 05 07:19 PM
Cleaning Product Code list mike meyer Excel Worksheet Functions 6 April 11th 05 08:15 PM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017