bencar
Banned user
- Joined
- Jun 8, 2016
- Messages
- 149
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:
<tbody>
</tbody>
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?
| Number | Book Title | Author | Price | Book Type |
| 1 | A Game of Thrones | George R.R. | $19.77 | hardcover |
| 2 | Go to Sleep | Adam Mansbach | $8.22 | paperback |
| 3 | A Dance with Dragons | George R.R. | $18.81 | paperback |
| 4 | The Hunger Games | Suzanne Collins | $4.94 | paperback |
| 5 | The Original Argument | Glenn Beck | $7.99 | hardcover |
| 6 | Heaven is for Real | Todd Burpo | $9.34 | paperback |
| 7 | Unbroken | Laura Hillenbrand | $13.99 | hardcover |
| 8 | Smokin' Seventeen | Janet Evanovich | $15.21 | paperback |
| 9 | In the Garden of Beasts | Erik Larson | $13.78 | paperback |
| 10 | Catching Fire | Suzanne Collins | $8.97 | hardcover |
<tbody>
</tbody>
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?
Last edited:
