Excel 2007 : excel 2007 formula help?

Hi there
new to this forum
got a strange question(for myself lol, i have included pics)
on sheet1, i have my products, which have a product code. this product code determines which category the products go into...
on sheet2 i have the product codes and the categories...
with me? :D
on sheet1, i need to enter a formula that will look to the cell h2 for the product code, then goto sheet 2 to find the product code and the 3 cells next to it, then place the 3 cells of data onto sheet1 to fill in the categories box.....
i already have some categories filled in, but by hand, and when there's 11k of products, no thank you lol :D

i reallly hope ppl understand me lol

Something along these lines will do what you require, but as the data ranges, extents and sheet names, you'll have to adjust to suit.

hmm, ok that confused me lol, i have NO idea what that is or how to alter it to suit my needs
sorry im a nub with excel & formula's...
iv tried that formula with altered cells...so instead of $m$1 its $b$2 etc...(i tihnk thats right)
and dont work :S
just gives #N/A

There's information on why you should change your thread title here, and information on how to attach here

If you want help with a spreadsheet, why would you include a picture rather than a spreadsheet? It just means we have to spend time trying to recreate your workbook to test on.

Try the attached. Since you want three columns of data for each row, I used INDEX and MATCH formulas rather than VLOOKUP.

Originally Posted by spid3r1987

that was really quick!!! and it worked

The benefits of having a workbook to play with.

Thanks for the rep (you are my 1000th point )

spid3r1987,

before you create another post, please take a look at the forum rules, especially with regards to thread titles and then amend this thread to some more meaningful title. Describe what you want to achieve. That is always a good starting point for a suitable title.

Thanks.

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.