Lookups

[ds_robb]

Is there a way of having a cell location returned. I am trying to check down a failry long list of entries and I need to know which row the item appears in.

For example... Data to be searched "ROBB"
A
1 EVANS
2 PETERS
3 ANDREWS
4 ROBB
5 MORGAN

I am looking to get something to report the data was found on row 4 or A4.
Thanks

 

[PaddyD]

Hi:

=MATCH("ROBB",A1:A6,0)

for the '4',

=ADDRESS(MATCH("ROBB",A1:A6,0),1,4,1)

for 'A4'

Paddy

 

[Aladin Akyurek]

On 2002-08-31 16:13, ds_robb wrote:
Is there a way of having a cell location returned. I am trying to check down a failry long list of entries and I need to know which row the item appears in.

For example... Data to be searched "ROBB"
A
1 EVANS
2 PETERS
3 ANDREWS
4 ROBB
5 MORGAN

I am looking to get something to report the data was found on row 4 or A4.
Thanks

=MATCH("ROBB",Range)

where Range refers to the range housing names, will return the location/position of the lookup value.

=ADDRESS(MATCH("ROBB",Range),COLUMN(Range))

will return the address of the lookup value.

 

[ds_robb]

Thanks very much guys.
Regards
Duncan