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.