| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Type item# and have the description autofill in next column
I have a spreadsheet with all our item numbers in column A and all the
descriptions in column B. In another spreadsheet I have to manually type item numbers from orders and would like to have the descriptions automatically carry over from the other spreadsheet to avoid manually typing them in each day. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Type item# and have the description autofill in next column
you need to use the vlookup function, explained in excel help, and external
references, explained he http://office.microsoft.com/en-us/ex...023381033.aspx "beccadawn0622" wrote: I have a spreadsheet with all our item numbers in column A and all the descriptions in column B. In another spreadsheet I have to manually type item numbers from orders and would like to have the descriptions automatically carry over from the other spreadsheet to avoid manually typing them in each day. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Type item# and have the description autofill in next column
I am still not getting it to work. It says "not enough memory" but I'm not
sure I am even doing it right. Need more specific help THANKS!!!!!!!!!! "dlw" wrote: you need to use the vlookup function, explained in excel help, and external references, explained he http://office.microsoft.com/en-us/ex...023381033.aspx "beccadawn0622" wrote: I have a spreadsheet with all our item numbers in column A and all the descriptions in column B. In another spreadsheet I have to manually type item numbers from orders and would like to have the descriptions automatically carry over from the other spreadsheet to avoid manually typing them in each day. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Type item# and have the description autofill in next column
Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting the data if need be. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 06:51:01 -0700, beccadawn0622 wrote: I am still not getting it to work. It says "not enough memory" but I'm not sure I am even doing it right. Need more specific help THANKS!!!!!!!!!! "dlw" wrote: you need to use the vlookup function, explained in excel help, and external references, explained he http://office.microsoft.com/en-us/ex...023381033.aspx "beccadawn0622" wrote: I have a spreadsheet with all our item numbers in column A and all the descriptions in column B. In another spreadsheet I have to manually type item numbers from orders and would like to have the descriptions automatically carry over from the other spreadsheet to avoid manually typing them in each day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up an item by starting to type see possible choices | Excel Discussion (Misc queries) | |||
| Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
| enter item code in one column, automatically get description in ne | Excel Worksheet Functions | |||
| Autofill type feature. | Excel Worksheet Functions | |||
| How do I use a" item description" in excel to consolidate totals? | Excel Discussion (Misc queries) | |||
Linear Mode
