Creating a worksheet that autofills values

[jmlovetto]

Hello,

I'm new to this forum, and only a bit above average user of Excel, so please take it easy on me.

I'm trying to create an autofill form where I can type a number in column A (for instance) and have column B and C pull the correlating information from another sheet and autofill the values. This is for a customs paperwork, where we have to fill out tariff codes for each and every product we ship. it gets redundant having to look it up each and every time we have to ship something. I would look it up, if I knew how to pose the question. There's a lot of information out there, if you know what to look for...

Any help would be appreciated!

Thank you,
jmlovetto

[Tony Valko]

See if this helps...

http://contextures.com/xlFunctions02.html

[jmlovetto]

Thank you Tony, I will check that out!

[jmlovetto]

Tony, that worked like a charm. The =vlookup function is likely a very basic formula, but very useful. Thank you!

Now, if I can only find a way to drag the formula down 2416 lines and only have the first lookup value change with each line, without it changing the table array, column index number and range lookup, I'll be in business!

Thank you again,
jmlovetto

[jmlovetto]

In case anyone runs across this thread in search of the same information I was looking for, I discovered how to drag your vlookup formula to other cells, and NOT change the formula based on a circular reference:

Step 1
Open the Excel 2010 file where you want to copy the VLookup function down to multiple rows.

Step 2
Click on the cell that contains your VLookup formula. Place your cursor into the formula bar located just above the spreadsheet so that you can edit the formula.

Step 3
Place dollar sign symbols in front of any ranges that you don't want to change when you copy your formula down. Excel uses relative references when copying formulas, so if your VLookup function referenced the range A1:D10 and you copy that formula down one cell, the range would change to A2:D11. By placing dollar signs in front of each reference element, such as $A$1:$D$10, you ensure that the reference will not change when you copy the formula. This is especially important when copying VLookup formulas, as the table range should remain constant. Press "Enter" when you are done making changes.

Step 4
Click the cell that contains the VLookup formula. Move your mouse to the small, black box, called a fill handle, in the lower right corner of the cell. Your mouse cursor will change into a plus sign when you are correctly positioned over the box.

Step 5
Click and hold the mouse button on the fill handle. Drag the mouse down the spreadsheet until you reach the last row where you want the VLookup formula to reside. Release the mouse button, and the formula will be instantly copied to all the rows between the original cell and the cell where you released the button.

Voila! Enjoy spreadsheeting!!!