No Clue

[miahson]

I have a question for anyone that can help?
I have a computer store, and I have SKU numbers for each item within the store. I have a Special Order spreadsheet file (A)with Quantity, Sku, Item Description, Price. I also have (in another spreadsheet file (B)) a list of all the items I can order from the business HQ (huge list). What I want to be able to do is this! In spreadsheet file A: type in the Sku number in cell A, in the next cell to the right have it auto-fill (from the spreadsheet file B) the item description, and to the right of that have it auto-fill (from the spreadsheet file B) the price. How would I do that?

QTY SKU # Item Description Price

(type this) (auto-fill this) (auto-fill this)
12345 Ipod Touch 8GB 299.00

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely 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 a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[NBVC]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.