- 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