Columns Function in Vlookup Fails to Return a Third Column.. Please Help

[bencar]

I'm using the COLUMNS function in a vlookup to find author, price and book type by entering only book title. Its able to return author and price. But it fails to bring up book type. The vlookup formula is below:


[TABLE="width: 543"]
<tbody>[TR]
[TD]Number[/TD]
[TD]Book Title[/TD]
[TD]Author[/TD]
[TD]Price[/TD]
[TD]Book Type[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A Game of Thrones[/TD]
[TD]George R.R.[/TD]
[TD]$19.77[/TD]
[TD]hardcover[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Go to Sleep[/TD]
[TD]Adam Mansbach[/TD]
[TD]$8.22[/TD]
[TD]paperback[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]A Dance with Dragons[/TD]
[TD]George R.R.[/TD]
[TD]$18.81[/TD]
[TD]paperback[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]The Hunger Games[/TD]
[TD]Suzanne Collins[/TD]
[TD]$4.94[/TD]
[TD]paperback[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]The Original Argument[/TD]
[TD]Glenn Beck[/TD]
[TD]$7.99[/TD]
[TD]hardcover[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Heaven is for Real[/TD]
[TD]Todd Burpo[/TD]
[TD]$9.34[/TD]
[TD]paperback[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Unbroken[/TD]
[TD]Laura Hillenbrand[/TD]
[TD]$13.99[/TD]
[TD]hardcover[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Smokin' Seventeen[/TD]
[TD]Janet Evanovich[/TD]
[TD]$15.21[/TD]
[TD]paperback[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]In the Garden of Beasts[/TD]
[TD]Erik Larson[/TD]
[TD]$13.78[/TD]
[TD]paperback[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Catching Fire[/TD]
[TD]Suzanne Collins[/TD]
[TD]$8.97[/TD]
[TD]hardcover[/TD]
[/TR]
</tbody>[/TABLE]

Heres the vlookup formula with COLUMNS function in it:
=VLOOKUP($B$13,$B$2:$D$11,COLUMNS($B:B)+1,0)

This formula is pasted across 2 other columns for a total of 3 columns to return author, price and book type. But as I said, only author and price come up, not book type. Why is this happening? How do i fix it?

 

[sericom]

=vlookup($b$13,$b$2:$e$11,columns($b:b)+1,0)

 

[sheetspread]

Extend the range to E

 

[Momentman]

Booktype is in column E, I guess

If that's the case, then change $B$2:$D$11 to $B$2:$E$11

 

[bencar]

Booktype is in column E, I guess

If that's the case, then change $B$2:$D$11 to $B$2:$E$11

Wow!!! I cant believe I missed that! Thank you!!