I have 2 worksheets

worksheet 1 = score
worksheet 2 = jan

i have a function in the 'score' worksheet where i want to lookup what row i am in

once calculated i would like to use that row reference within another function so i can add data from the 'jan' worksheet

the row reference is important, as it will allow me to find the necessary data in the 'jan' worksheet

i know the row reference forumla is

row()

but when i enter in

+JAN!L(row())

it doesnt work

it comes up with

#name?

please help