The information is available on a page labelled "entrants", where the names are in columns A and B and the start location is in column L. Using the formula in the new page of =entrants.A# and =entrants.B# works as expected, the names appear in each cell. However when I enter the formula =entrants.L# for the start location, the result in each cell is simply the text of the formula.
I have checked the format of the cells where I placed the formula and nothing appears strange. Can anyone tell me what the problem could possibly be and how I can fix it?
Thank you,
Arnold Roth
Edit: Email removed; Hagar, Moderator. |