Hi I have a job where I have 12 song titles on an A6 card but each card cant have the same sequence of song titles on it so each card is unique.
I have been given an excel doc with 12 columns of random numbers from 1 to 22.
I have 22 song titles ie U2 That I need to associate with say number 1 so that whenever number 1 comes round in the data that is the song title it will put in.
I have tried making number 1 CONDITIONAL U2 but this doesn’t work?
All the random number data and the song titles are in the same excel doc in different columns.
Im thinking its because the excel doc needs to be set up differently in order for me to populate the info?
Any help would be appreciated.