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

**BamBamMoneyBags** · 02-08-2013, 02:34 AM

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.

**Fotis1991** · 02-08-2013, 02:57 AM

Try

=IFERROR(INDEX(Sheet2!C2:C11,MATCH(A1,Sheet2!D2:D11,0)),"Number does not exist")

**FDibbins** · 02-08-2013, 03:00 AM

try using index/match instead of vlookup...
=INDEX(Sheet2!$A$2:$D$11,MATCH(Sheet3!$A$1,Sheet2!$D$2:$D$11,0),1)

=index(range,row,column) so, to return other columns, either change 1 to 2 etc, or, if you have column headings, you can use these in a 2nd match() function so you dont have to manually adjust the index() function.