how does it differ to 2003?
in 2003 you'd do =vlookup([RangeContainingUniquieID1stSheet],[RangeContainingUniquieID2ndSheet],1,False)
then all those that return #N/A are the ones that are missing
Posted By: Ralf Scrampton on February 24th 2012 at 15:58:59
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.