+ Reply to Thread
Results 1 to 2 of 2

How to use vlookup if value of lookup cell is same in lookup range

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    india
    MS-Off Ver
    MS office 2010
    Posts
    16

    How to use vlookup if value of lookup cell is same in lookup range

    Untitled.jpgHello All, can somebody help me
    i have to make a online Pareto Chart for check real time defect contributor in our production machine, I have an Database sheet of defect, i uses large =LARGE(B$4:B$15,1).....11 formula to make descending order of defects,Then i use VLOOKUP to match the defect with his contribution, But when the lookup value is same in entire range its give me only one value repeated again and again, is it possible to get all defect name from the entire range.




    Thanks in Advance
    Attached Files Attached Files
    Last edited by anujteetwal; 05-09-2014 at 05:13 AM. Reason: snapshot of excel book

  2. #2
    Registered User
    Join Date
    01-11-2012
    Location
    india
    MS-Off Ver
    MS office 2010
    Posts
    16

    Re: How to use vlookup if value of lookup cell is same in lookup range

    Attachment 317205

    snapsnot of excel book

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 10-04-2012, 05:17 AM
  2. Help with Vlookup- lookup value range?
    By asburytl in forum Excel General
    Replies: 7
    Last Post: 08-04-2011, 02:24 PM
  3. [SOLVED] VLOOKUP range lookup
    By xtreme_fac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2005, 06:50 AM
  4. [SOLVED] Range Lookup in VLookup ?'s
    By Bronco_Junkie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2005, 06:20 PM
  5. Range Lookup in VLookup ?'s
    By Bronco_Junkie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2005, 06:17 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