I want to input a part# into A1 and have its description appear in A2

**Lojinxx** · 07-01-2019, 11:02 AM

Hey everyone. First off, I'm new to these forums. If this is the wrong place to post this I apologize and will be happy to move it. Just let me know.

I am creating a form at work. I want to be able to punch an item number into a cell(A1 for example), have that number stay there and have the cell to the right of that(B1) populate with an item description. I want the form to do this in about 30 rows so I can go down column a and punch in item numbers and have their descriptions populate. I have an Item Master list of our inventory with item numbers in column A and descriptions in column B. I copy/pasted those 2 a second sheet in the workbook. I found a nice little guide about vba lookup(A_Quick_Guide_to_the_VBA_VLookup]) and thought I was on the path to success, but by the end of the guide realized they weren't giving me everything I need. At least I don't believe they were. Any help I can get is greatly appreciated. Thank you.

**AliGW** · 07-01-2019, 11:07 AM

Welcome to the forum!

You don't need VBA for this. You can use a simple VLOOKUP or INDEX MATCH formula.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

**Lojinxx** · 07-01-2019, 11:36 AM

Hello AliGW. Thank your for responding so quickly and giving me such clear directions for how to get help.

I've attached a mock worksheet and a photo of what I'd like it to look like in the end. Thanks in advance to anyone who's able to help.