I have a quick question:
Is it possible to write an item code like "IT48TA" and get as a result a full description of the item in the following cell?
I'm working on an Excel worksheet for quotes at my dad's furniture store, so if a customer asks for a quote on different items, I'd like to make things super easy for my dad so he goes to the file and fills the item box, which ideally would give him automatically the description of the item on one cell and the price in other. Then he just has to print the quote and hand it to the customer without much wait.
I have all the descriptions and items in other file, but you have to copy everything from there and it's a slow process.
Edited by sanpt7777, 16 November 2015 - 12:11 AM.