Row Reference & Cell Lookup

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

Hi,

I am not sure to fully understand you request ...
But if you need to return a row number, instead of vlookup(), you should use the match() function

=match(yourcell,jan1!A1:A100,0)

HTH
Carim

Originally Posted by oldchippy

Take a look at this link on vlookup tables

http://www.contextures.com/xlFunctions02.html

thanks for the tip, i think this one works just fine for me

thanks all for the quick responses!