VLOOKUP Function to display entire row of value selected via drop-down list

Hello,

I'm trying to use the VLOOKUP function to populate some cells based on my drop-down list selection, however, I'm getting N/A errors.

Attached is my sample file.

Sheet 2, which is populated from Sheet 1, contains my list, where I'm extracting the information.

Sheet 3, cell A1 is where the Drop-down list is selected.

I'd like cell B2 on Sheet 3 to point to Column C of Sheet 2, depending on my drop-down selection.

I'm thinking that I must use the VLOOKUP function AND the MATCH function to accomplish this.

Let me also add that I need the list on Sheet 2 to be a dynamic named range.

Thanks for reading, and for the help if possible.