Hi guys,
Got a question about vlookup with columns functions. I use, VLOOKUP($B16,$B$4:$D$13,COLUMNS($B:B)+1,0) and I paste the formula across cells C16 and D16 to return matches of author and price. But when I use B$16 instead of $B16 in the formula, it returns a match in author but not price. If it returns a match in author why cant it return a match in price??
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Got a question about vlookup with columns functions. I use, VLOOKUP($B16,$B$4:$D$13,COLUMNS($B:B)+1,0) and I paste the formula across cells C16 and D16 to return matches of author and price. But when I use B$16 instead of $B16 in the formula, it returns a match in author but not price. If it returns a match in author why cant it return a match in price??
A | B | C | D | |
---|---|---|---|---|
3 | Number | Book Title | Author | Price |
4 | 1 | A Game of Thrones | George R.R. | $19.77 |
5 | 2 | Go to Sleep | Adam Mansbach | $8.22 |
6 | 3 | A Dance with Dragons | George R.R. | $18.81 |
7 | 4 | The Hunger Games | Suzanne Collins | $4.94 |
8 | 5 | The Original Argument | Glenn Beck | $7.99 |
9 | 6 | Heaven is for Real | Todd Burpo | $9.34 |
10 | 7 | Unbroken | Laura Hillenbrand | $13.99 |
11 | 8 | Smokin' Seventeen | Janet Evanovich | $15.21 |
12 | 9 | In the Garden of Beasts | Erik Larson | $13.78 |
13 | 10 | Catching Fire | Suzanne Collins | $8.97 |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2