Results 1 to 10 of 10

Match 1st and 2nd columns in 2 sheets and return 3rd,4th and 5th column if match.

Threaded View

shaXad Match 1st and 2nd columns in... 12-15-2013, 10:53 AM
popipipo Re: Match 1st and 2nd columns... 12-15-2013, 11:26 AM
shaXad Re: Match 1st and 2nd columns... 12-15-2013, 11:40 AM
shaXad Re: Match 1st and 2nd columns... 12-15-2013, 12:07 PM
popipipo Re: Match 1st and 2nd columns... 12-15-2013, 03:10 PM
martindwilson Re: Match 1st and 2nd columns... 12-15-2013, 03:41 PM
shaXad Re: Match 1st and 2nd columns... 12-16-2013, 03:56 AM
shaXad Re: Match 1st and 2nd columns... 12-16-2013, 03:59 AM
shaXad Re: Match 1st and 2nd columns... 12-16-2013, 04:02 AM
vlady Re: Match 1st and 2nd columns... 12-16-2013, 03:59 AM
  1. 12-15-2013, 03:41 PM #6
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Match 1st and 2nd columns in 2 sheets and return 3rd,4th and 5th column if match.

    no need for helper column in this instance
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match 3 set of columns and return value from another column in case of a unique match.
    By hisaurabhmact in forum Excel General
    Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  2. [SOLVED] Two Excel sheets trying to match text data and return the match from the second column!
    By bankcott in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 02:17 PM
  3. [SOLVED] Match Multiple columns across multiple sheets return TRUE if match found
    By klundtasaur in forum Excel General
    Replies: 2
    Last Post: 06-29-2011, 01:36 PM
  4. Match 2 columns in 2 sheets and return the 3rd column
    By swadson in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-16-2011, 04:36 PM
  5. Excel 2007 : Match 2 columns to return the value of the third column
    By anansc89 in forum Excel General
    Replies: 6
    Last Post: 03-01-2011, 06:23 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1