I am not good at excel! I need a CELL to RECOGNIZE the code put into a cell and look it up in a vertical list of 50 or so numbers, if it finds a match enter a value from the next column into the original cell. Thanks for any help!!!Does anybody have any ideas? Did I give enough info?Go to Excel's Help and search for info on the VLOOKUP and HLOOKUP functions. I'm not very familiar with those functions but I believe VLOOKUP MAY be what you need.Agreed, VLOOKUP would be a useful function in this case. However, you should plan on having to toy around with this for quite awhile because I don't think this is going to be as simple as you would like. If you have the extra cash lying around, you might want to CONSIDER investing in a New Perspectives book; you could learn a lot of handy features.In case you need the answer before you have time to go to the bookstore, Datapig is a GREAT site for help on Excel functions. They have a quick video tutorial on VLOOKUP at

http://www.datapigtechnologies.com/flashfiles/vlookup.html

It's pretty straightforward once you get the hang of it. Unlike your original request, it won't put the new answer in the "original" cell, but you can put the answer based on the original wherever you like.Quote from: notamused on May 21, 2008, 10:40:54 PM

In case you need the answer before you have time to go to the bookstore, Datapig is a great site for help on Excel functions. They have a quick video tutorial on VLOOKUP at

http://www.datapigtechnologies.com/flashfiles/vlookup.html