+ Reply to Thread
Results 1 to 3 of 3

Vlookup - Comparison Between Tabs

  1. #1
    Forum Contributor
    Join Date
    02-10-2007
    MS-Off Ver
    Excel 2010
    Posts
    293

    Vlookup - Comparison Between Tabs

    Hello,

    I want to compare data that is on tab a, with data on tab b, tab c. Anything on tab b and tab c, which is not on tab a, display in final tab, everything else leave blank.

    Basically, it there is a match between data on tab b, and tab c, and it matches data on tab a, leave blank.

    Comparing column A among the tabs.
    Please see attached spreadsheet, final tab.

    Thanks in advance
    Attached Files Attached Files
    Last edited by VegasL; 06-03-2008 at 01:42 PM.

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day VegasL,


    Try this,
    Attached Files Attached Files
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Contributor
    Join Date
    02-10-2007
    MS-Off Ver
    Excel 2010
    Posts
    293
    thanks for helping ratcat. appreciate your time.

    actually in final tab, im trying to get the result to display in column a, of final tab, after comparing tabs a,b,c

    sorry for any confusion

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1