- Messages
- 16
- Reaction score
- 13
- Points
- 3
Ohh. It's alright I get it You helped alot! And if in the paper it isn't specified whether they want reports in portrait or landscape, can we print them in landscape if by any chance the records are getting cut?w11 qn 9. normal vlookup fnxn.
column index no.: (a/c ms: 1+ value(mid(cell ref)).) dis is coz the comparision will b made, bt 4m wr will d comp show d data, cz it cant show d whole row? u cant straightaway put 1 or 2 or wtver coz it is relative 2 d album. so, wn u look at d top of d spreadsheet of N11Tracks, u c dat d album names r written. u use dat. bt if u only add value(mid(cell ref)), it will show d track of d 1 b4. so u +1.
ask Student of the year if u didnt get it yet. sorry 4 d limited help.