Hi,

I am comfortable with standard vlookups but I have a situation that I think
vlookup can help with but I want a different answer brought back.

An my first sheet I have a list of codes that I know exist on the second
sheet, the problem is that there may be duplicates on the second sheet with
different information.

What I would like is if the code exists more than once I would like it to
flag this for me, if it does only exist once then show me the information in
specified column.

I hope I have explained this well enough but just let me know if you need
more info.

Thanks
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)