Type item# and have the description autofill in next column

[beccadawn0622]

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.

 

[dlw]

you need to use the vlookup function, explained in excel help, and external
references, explained here:

http://office.microsoft.com/en-us/excel/HP101023381033.aspx

 

[beccadawn0622]

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!!!!!!!!!!

 

[Gord Dibben]

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