Databasing in Excel...I'm in way over my head
 

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/

Databasing in Excel...I'm in way over my head
 

You need to use the lookup funtions of Excel. Take a peek at the vlookup
function in Excel help, it gives you directions on how to use and some
examples.

Cheers
Nigel

"abxy " wrote in message
...
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/





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

Databasing in Excel...I'm in way over my head
 

Hi,

First, create worksheet, where you list all the item IDs an
descriptions. For Ex. Column A contains the IDs and column B thei
descriptions. Rename this sheet as "Data"

Now go back to the sheet, where you enter product returns and type th
following formula to the cell, where the description supposed to be :

=VLOOKUP(x;y;z)
where
x:= address of the cell, where you enter the ID of the returne
product
y:= address of the table, which contains the ID's and the descriptio
of the products
z:= index of the column to be returned as description from the "Data
sheet (in this case 2nd column)

I also attached an example fil

Attachment filename: examp.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42230
--
Message posted from http://www.ExcelForum.com