Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm trying to figure out what would work best for data entry and retreval.
On one work sheet I would have my vendor and product categories both of
these would be referenced to numbers. Column1(vendors) Column2(product categories) Acme would equal 1 Widgets would equal 1 One the second worksheet I would have the first 2 columns would be referenced to the numeric value of the other worksheet (trying to save on size) the balance of the columns would be model number, description, pieces per package, cost, sell, msrp, date entered, date edited. Column1(vendors) Column2(product categories) Column3(model number) Column4(description) Column5(cost) Column6(sell) Column7(date entered) 1 1 Column8(date edited) To enter the data the form would have 2 combo boxes that would be from column 1 and 3 on the first worksheet but would enter the integer value in columns one and two of the second worksheet. The balance would be text boxes. To look up data I would like to be able to use any of the of these columns - vendor, product category, model number and description to input the information into a quote sheet. Is this doable in Excel? I have tried several of the quote software that's available and nothing covers everything I need. Marc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm trying to figure out what would work best for data entry and retreval.
check out VLOOKUP, there are lots of posts of this in your forum and in the many excel websites such as he http://www.contextures.com/xlFunctions02.html -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=528940 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm trying to figure out what would work best for data entry and retreval.
Dave if I'm not mistaken VLOOKUP only works if your "standard" is in the far
left column. Marc "davesexcel" wrote in message ... check out VLOOKUP, there are lots of posts of this in your forum and in the many excel websites such as he http://www.contextures.com/xlFunctions02.html -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=528940 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm trying to figure out what would work best for data entry and retreval.
That is correct. If it isn't, use a combination of index and match
=Index(columnA, match(value,columnB,0),1) as an example. -- Regards, Tom Ogilvy "Marc" wrote in message hlink.net... Dave if I'm not mistaken VLOOKUP only works if your "standard" is in the far left column. Marc "davesexcel" wrote in message ... check out VLOOKUP, there are lots of posts of this in your forum and in the many excel websites such as he http://www.contextures.com/xlFunctions02.html -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=528940 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A What-if scenario changing one figure to work out another | Excel Worksheet Functions | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Can't figure out why Macro wont work???? | Excel Worksheet Functions | |||
VBA Help, cant figure out why it dosn't work. | Excel Programming |