Results 1 to 8 of 8

Vlookup value return first cells only corresponding to the multiple refeence and column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Vlookup value return first cells only corresponding to the multiple refeence and column

    Sir,

    with refer to the above subject I want Vlookup Value return first cells only against multiple reference and column.

    am using this formula value return is perfect when data without duplication. if data duplication value return is multiple time as same value.

    =VLOOKUP($A2&B2&C2,CHOOSE({1,2,3},Data!$A$2:$A$11&Data!$B$2:$B$11&Data!$C$2:$C$11,Data!$D$2:$D$11),2,0)

    file attached. please help me.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP to return multiple cells of same lookup value
    By gerardog92 in forum Excel General
    Replies: 6
    Last Post: 01-24-2014, 03:35 AM
  2. VLookup with multiple return cells - Can I sum these up?
    By AnnaG87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2013, 03:36 PM
  3. Vlookup to return multiple corresponding column values
    By ebdmbfan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-29-2013, 04:33 PM
  4. VLookup - Return multiple values in multiple cells HELP
    By sreeves1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2012, 12:58 PM
  5. Baseball Q - Return Multiple Matches in Column/VLookup?
    By TENNISMAN in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-17-2007, 03:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1