Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Over My Head | Excel Discussion (Misc queries) | |||
Printing Excel Documents from Head to Toe | Excel Discussion (Misc queries) | |||
How to select and print custom data (eg: cell value) in excel head | Excel Discussion (Misc queries) | |||
Mailmerge problem from Excel to Word placies data 1st row in head | Excel Discussion (Misc queries) | |||
insert image in head excel file? | Excel Discussion (Misc queries) |