lookup part description and price from different tabs

**beerbowerr** · 04-13-2012, 12:11 PM

I am trying to build an order form that will auto populate part descriptions and two different price feilds from multiple work sheets when I enter a line code and a part number. The workbook I am working with has 46 differnt sheets, one each from my different vendors and all have various amounts for rows. All of the collums are laid out the same in each sheet. I have be trying to figure this out for several hours and have no luck any help would be great.

**Russell Dawson** · 04-13-2012, 12:25 PM

Please correct your title in accordance with the forum rules.

. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

**icestationzbra** · 04-13-2012, 01:14 PM

@beerbowerr:

change your title to something like 'lookup part description and price from different tabs' or some such.

see attached file - is this close to what you are looking for? choose different values for Line and Part # and have the 3 other columns populate automatically whenever you attach a file, it is also a good idea to key in some sample results so that we know what you are expecting.

**beerbowerr** · 04-13-2012, 01:41 PM

Sorry about the Title. Yes this is exactly what I was trying to do Thank you.

**beerbowerr** · 04-13-2012, 01:46 PM

Is there a way to set it up so I can just Key in the Line and Part number and not have to select it from a drop down? Thanks again for all of your help

**icestationzbra** · 04-13-2012, 04:10 PM

columns A and B will allow you to enter a Line and Part value in the respective fields without forcing you to select one from the dropdown list. however, if an incorrect value is entered, xl will scream.

**beerbowerr** · 04-13-2012, 04:59 PM

I cant seem to get this to work on my large sheet. I am not sure how to correctly built the list for line and part.

**icestationzbra** · 04-13-2012, 05:13 PM

there two things you need to take care of - Data Validation and Named Ranges.

Named Ranges: ALT > M > N

in the spreadsheet that i uploaded, there should be 6 Named Ranges. you can see the detail of each Named Range by selecting it and clicking on Edit. use the exact names and then create similar and corresponding Named Ranges for your actual data. the names you use are key because they will be used in Data Validation.

Data Validation: select cell A2, followed by ALT + A + V + V. you will see the list of values that appear in column A cells (A2:A501).

now select cell B2, followed by ALT + A + V + V. now you will see the formula that generates the list for column B cells (B2:B501).

then there are the VLOOKUP formulae in columns C through E.

give it a try and see how far you can get. holler back in case you need help.