Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
enter item code in one column, automatically get description in ne
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
enter item code in one column, automatically get description in ne
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)),"",vlo okup($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 "Shelley Kingston" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
enter item code in one column, automatically get description in ne
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 Shelley Kingston wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 columns and choose one and enter answer in third column | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |