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.

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.

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.

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.