Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto-Enter Value Based on Table (EXCEL 2002)
Ladies and Gentlemen:
I am trying to do something that seems like it should be very simple, but I cannot, for the life of me, figure out how to get it to work. I want to create a basic table in Excel, Column A being Supplier Number and Column B being the Supplier Name. On a seperate worksheet, I need to enter BOTH items of information in a simple form I created. I am trying to set it up so that once I enter the Supplier Number in one box, then the Supplier Name will automatically be entered in the appropriate box based on the simple table of Supplier Number and Supplier Name. I have tried many, many sources to try to find the answer to this problem, but have had no luck at all yet. Can someone please assist me with this problem, or am I thinking it should be simpler than it actually is? Oh, one more note, I don't want to use Access to design this form for work reasons. I need to have this work in Excel, so advice on how to do this would be greatly appreciated. Thanks Very Much, Christopher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a Excel 2004 file in Excel 2002 | Excel Discussion (Misc queries) | |||
paste excel table to word | Excel Worksheet Functions | |||
Paste table from excel to word | Excel Worksheet Functions | |||
How do I get a table from IE into excel? | Excel Worksheet Functions | |||
How do I display a data table in an Excel 2002 chart? | Charts and Charting in Excel |