My boss asked for this, and I have no idea how to do it. He wants to be able to type into a cell a number of a product that we make, and have it replaced with the description. We have about 300 products and he gave me a list with the product numbers and descriptions. Is there any way to do this? I don't think he would mind if the description appeared on a different cell.
Use VLOOKUP
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I don't know how to use the vlookup. if they type in the number where in the bottom values does it go? where does the list where they're being looked up go? Where does the info that they need to bring back go? and where does the location of the info retured go in the bottom values?
Lookup_value
Table_array
Col_index_num
Range_lookup
type in
8
get back
Product 8
Number list
1
2
3
4
5
6
7
8
Produt List
Product1
Product2
Product3
Product4
Product5
Product6
Product7
Product8
Last edited by hsalazar; 02-09-2012 at 10:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks