|
|
#1
09-24-2011, 10:46 PM
|
|||
|
|||
Formula to select description when code is entered
I need to create a formula in the description column of an invoice (sheet2) to select from the imported items list (below is the first item - in Sheet1) when the code is entered. Please help.
Product Code Description BK400 4' x 3' Bookcase etc etc 
|
|
#2
09-25-2011, 12:59 PM
|
||||
|
||||
|
Welcome to the forum.
 Have a look at the VLOOKUP() worksheet function in the Excel helpfile. Once you've read the helpfile topic, please feel free to post back if you're not sure how to use it and we can try to help some more.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Invalid Product Key
|
djclinton | Office | 1 | 09-18-2011 09:29 AM |
| Product and Sum on 2 rows | apolloman | Excel | 2 | 04-27-2011 07:14 AM |
| product key | cplove | Office | 3 | 03-25-2010 09:17 PM |
| Product Key. | Spirit | Office | 0 | 02-02-2010 10:27 AM |
| product key | Tom-Aspin | Word | 1 | 01-25-2010 04:10 AM |
Windows XP 
Office 2010 32bit
Linear Mode
