Posted to microsoft.public.excel.misc

Michael

external usenet poster

Posts: 791

lookup row number

Hi,
can you tell me how to lookup the row number of a name in a list.

EG say I have a list of names as below:

Andrew
Mike
Steve
Ian
Paul

I would normally just add a column with the row numbers and then lookup the
row number in the second column but is it possible to do without adding the
extra column by using the row formula someohow?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup for Part of the number	Kiran	Excel Discussion (Misc queries)	3	April 9th 10 11:55 AM
Lookup less than a number	Rod	Excel Worksheet Functions	6	November 11th 08 02:46 AM
number lookup	wcthrill	Excel Worksheet Functions	1	April 4th 06 07:52 PM
Number Lookup in Matrix	Rod	Excel Worksheet Functions	12	July 2nd 05 11:24 PM
Lookup Highest Number	gregork	Excel Discussion (Misc queries)	5	December 14th 04 04:17 PM

All times are GMT +1. The time now is 10:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us