Hi Robert

The numbers being returned are the row numbers where a match is found. Since
you are dealing with column D, then the cell reference would be Dn where n
is your numeric value.

Wrapping your formula in an INDEX() function will return the URN's

=INDEX('Crime Report'!D:D,MATCH('Crime report'!D:D,'CSI report'!D:D,0))
but this will return #N/A where there is no match.

I'm not sure what you want to do with the data, or whether this helps.

An alternative approach could be to use a spare column on Crime Sheet and enter
=COUNTIF('CSI Report'!D:D,"="&D1)
and copy down the column.
This will return a 1 where there is a match and 0 where there isn't.
Mark your block of data and DataFilterAutofilter use the dropdown on the
column with your formulae to select the 1's


Regards

Roger Govier


RobPot wrote:
So apart from the thread hijack and solution above (!) - anyone got any
ideas?
(bump!)