Find Row Number (Excel 2003)

Topic

New Reply

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

Reply | Quote

Replies

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

=MATCH(StudyNumber,'Examine DataPool.xls'!B3:B100,0)

will return the row number within B3:B100 where StudyNumber is found. If you want the absolute row number, you can use

=MATCH(StudyNumber,'Examine DataPool.xls'!B3:B100,0)+ROW('Examine DataPool.xls'!B3:B100)-1

You can replace B3:B100 with a name if available.

Reply | Quote

Thanks, Hans that’s what I needed.

Reply | Quote