enter item code in one column, automatically get description in ne

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to enter a product code in one column and based on the code
i have entered, get the product description to automatically appear in the
column next to it.

There are approx. 150 product codes and descriptions.

I have all of the data saved in a separate spreadsheet, but can hide it on
the active spreadsheet if necessary.

Can this be done? (Please explain in simple terms!!)

Thanks!
 
Shelley,

Assuming your product code/product description data is in (for example)
Sheet2 columns A & B, and you enter a product code in A2 on Sheet1, then in
B2 on Sheet1 put:

=IF(isna(vlookup($A2,sheet2!$A:$B,2,false)),"",vlookup($A2,sheet2!$A:$B,2,false))

This will return the product description or blank if no product code found.

Change sheet names and ranges to suit.

[Copy formula down column B if required]

HTH
 
Hi Shelley;

You can use VLOOKUP for the same.

Main Data sheet:

1 A AB 234
2 B AC 25
3 C AD 24
4 D SD 21
5 E GT 32
6 F HY 45
7 G DE 34
8 H WE 23
9 I AS 23
10 J WE 12
11 K TR 12

Result sheet

1(product id) =VLOOKUP(B18,B4:E14,2,0)

Hope this would help you.

Regards

Vikky
 
Back
Top