Find Row Number (Excel 2003)

[CindyT]

Hi All, I think this may be easy and I'm just struggling ...

I use a vlookup up to find a value ...

=VLOOKUP(StudyNum,'Examine DataPool.xls'!StudyNumbers,4,FALSE)

Is there a way to determine the Row number where the value is found?

Thanks,
--cat

[HansV]

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.

[CindyT]

Thanks, Hans that's what I needed.