How to call details from a table on another page?

[Bojanlgez]

I'm building a spreadsheet with one worksheet that has all the data in it and i've mostly figured out how to build tables and define names and call values but i'm trying to make it more useful and it's getting more complex and i'm getting lost.

I have a sheet called "components" there's all the data in there about what it takes to build a particular item in the named range "item_parts". If i put in how many need to be built, it tells me what it'll take to build it and how much it'll cost. This part is all working perfectly.

Now what I want to do is have another sheet with a drop-down that allows me to pick from any of the items and once i've selected it, is to have the rows below to autofill with the data from the "components" page. So, when i select ITEM X, I want the rows beneath to show me the (say) 7 rows below it from the "Item_parts" range. This will help me plan out various, intricate projects without having to constantly and manually reference other items.

Trouble is, I'm not really even sure what commands to use - i've tried vlookup and hlookup with no success. Can anyone help me out here, or at least point me in the direction of the right commands?

thanks in advance

[NBVC]

Try something like:

=INDEX(Sheet1!A:A,Match(A1,Sheet1!A:A,0)+Rows($A$1:$A1))

where Sheet1 column A contains the lookup data.. and A1 is the drop down on your active sheet...

copy the formula down 7 rows to get 7 consecutive rows of data...

[Bojanlgez]

thank you - I'm not quite there yet, but evidently INDEX / MATCH was the combo I was looking for. If i can get it exactly right, I'll post it here and mark this as solved.

you have my thanks!