Copy Specific Row Using Results of Drop Down

[freddync]

Hello,

I have a drop down that copies the selction number to a cell (i.e. 1-19). I want to copy a specific cell from another worksheet based on the selection. The choices begin at G5, which would be the first item in the drop down. The rest of the data is G6-G25. I want to grab the data out of the specific row based on the drop down. Make sense?

Thanks for your help

[JBeaucaire]

Yes. I think so.

I use INDEX/MATCH for this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions.

Here's some sample sheets showing what I think you're looking to do.
INDEX-MATCH-Simple.xls
http://www.excelforum.com/attachment...tch-sample.xls

INDEX/MATCH explanation
http://www.excelforum.com/excel-gene...ame-row.html#3

[freddync]

This seems to be giving me an error?

=IF(F2="","",INDEX (Power Units'!$G$5:Power Units'!$G$25,MATCH($F2, Power Units'!$H$5:Power Units'!$H$25,0)))

[JBeaucaire]

=IF(F2="", "", INDEX(Power Units'!$G$5:$G$25, MATCH($F2, Power Units'!$H$5:$H$25, 0)))

You don't list a sheet reference more than once per ref.