If i knew Access, it'd be a great help, but unfortunately I don't, so
here's my problem:

I'm creating a Product Return Form for the Inventory department where I
work. Now, the thing is, there are 2 feilds, one for the system ID
number of the product, and the other for the description(name) of the
product. I'm trying to make it so that all you need to do is type in
the item ID and the corresponding product description will appear. When
I started, I used an IF function, basically saying if that cell has
this product ID in it, put the description in this cell. It worked.
Then I went to make it so that if the cell has a different Item ID in
it, it would display the description for the corresponding
product...but i'm stumped, how do I do that? ...also, it's not just 3
or 4 products, it's about 200 at least. How can I make this work?
Here's what I have:

=IF(A17="HNF0310221J","THINSULATE GLOVE..."," ")

How do I make it so that I can have more than one function working in
that cell, so that I can put in more item id's and corresponding
product names?


---
Message posted from http://www.ExcelForum.com/