Re: Find Row Number (Excel 2003)

You would need to specify the first column of the StudyNumbers range, or create a named range corresponding to the first column of StudyNumbers.

The formula
<code>
=MATCH(StudyNumber,'Examine DataPool.xls'!B3:B100,0)
</code>
will return the row number within B3:B100 where StudyNumber is found. If you want the absolute row number, you can use
<code>
=MATCH(StudyNumber,'Examine DataPool.xls'!B3:B100,0)+ROW('Examine DataPool.xls'!B3:B100)-1
</code>
You can replace B3:B100 with a name if available.