How to have a cell auto-generate text based on text from another cell?

**wgilles** · 06-30-2015, 10:19 AM

My spreadsheet has 2 worksheets. The first sheet is a "price quote" with a field for product code and one for description.
The second sheet has a list of all the product codes and descriptions.

So for example, if I type "Product A" into cell A1, is there a way to have "Description of Product A" auto generate in cell B1 by way of pulling the description from the second worksheet?

On the second worksheet, the product codes are in Column A and descriptions are in Column B. There are about 250 Products.

**JBeaucaire** · 06-30-2015, 10:26 AM

The function you would use is VLOOKUP().

=IF(A1="", "", VLOOKUP(A1, Sheet2!A:B, 2, 0))

**wgilles** · 06-30-2015, 10:50 AM

Originally Posted by JBeaucaire

The function you would use is VLOOKUP().

=IF(A1="", "", VLOOKUP(A1, Sheet2!A:B, 2, 0))

Thank you, that worked!

**JBeaucaire** · 06-30-2015, 02:46 PM

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.