You can use countif function
=countif(range of unique cells from sheet two,cell from sheet one)
If it returns 1 then it exists and if it's 0 then it doesn't.
Posted By: wobbly on February 24th 2012 at 17:58:58
Message Thread
- VLookup in Excel 2007 (General Chat) - Lurkerino, Feb 24, 15:33:16
- You can use countif function (General Chat) - wobbly, Feb 24, 17:58:58
- how does it differ to 2003? (General Chat) - Ralf Scrampton, Feb 24, 15:58:59
- Watch out for the $'s (General Chat) - King, Feb 24, 16:16:04
- yes, f4 them buggers right up there (n/m) (General Chat) - Ralf Scrampton, Feb 24, 16:17:40
- Watch out for the $'s (General Chat) - King, Feb 24, 16:16:04
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.