RE: formula to display cell data if another cell has a specific text (multiple options)

I will try to be clear, but you know how these things go. Here is an example of data on one worksheet (work sheet 1):
Column 1 Column 2
Row 1: Boy 100
Row 2: Girl 200
Row 3: Dog 300
Row 4: Cat 400

On a separate worksheet (sheet 2), I would like to create a drop down list in a cell (for ease we will put this in cell "D1") with all the words which are listed in column 1, where you can select to display one word off the drop list (there will be 30 options from this list).

Next, I would like to create a formula in a completely different cell (let's make this one "F1") which, according to what word is displayed off the list is visible in cell "D1", the formula will display the corresponding cell information in cell "F1" from column 2. For instance, if I choose "Boy" from the drop down list in cell "D1", then I would like cell "F1" to display "100". If I choose "Girl" for "D1", I would like "200" to display.

I would like to thank everyone ahead of time for helping me with this matter!!!!!!!

Thanks Etaf!!!! First response and you hit it right on the nail!!!

I was having the same problem finding a formula, this works great. My question is though if say there are two or more rows that say boy or girl but column 2 has a different number is there a way to get each one to list in different rows. So say:
Row 1: Boy 100
Row 2: Girl 200
Row 3: Dog 300
Row 4: Cat 400
Row 5: Boy 200
Row 6: Girl 400

And have the multiples display in say "F2", "F3", "F4"..., without getting duplicates? I hope this makes sense, thank you very much if you any way help with this!