- Messages
 - 31
 
- Reaction score
 - 53
 
- Points
 - 28
 
heythis is the formula =HLOOKUP(B2,Book orders'!$D$1:$L$21,VALUE(VLOOKUP($A$2,Book orders'!$A$2:$B$21,2,FALSE)),FALSE)
Create a new column in table Book orders that shows the row number for each student, and then use this as the col_index number. hope this helps
can u say me where did the Twex band name come up in summer 2012 paper 4 Task2
