looking up data

**andrewplayford** · 03-23-2007, 06:16 AM

Hi there this is my first post here so i am not sure if this is the correct section to post this problem in.

My problem is . . . I have an excel spread sheet conaining 2 sheets.
The first sheet contains names and amounts and the second sheet contains names and amounts.

What i would like to do is use a formula that if the names and amounts match on both sheets they are removed and the ones that dont match are left or if easier the ones with the names and amounts dont match are put in a seperate sheet on its own.

hope this makes sense and i hope someone will be able to point me in the right direction.

Many thanks

Andy

**oldchippy** · 03-23-2007, 06:24 AM

Hi,

Welcome to the forum, may be this link might help

http://www.j-walk.com/ss/excel/usertips/tip073.htm

**andrewplayford** · 03-23-2007, 06:53 AM

oldchippy, thanks for the link

it's nearly on the right lines.

My spread sheet contains two different sheets, although the numbers are highlighted it doesnt seem to compare them accurately.

thanks

Andy