+ Reply to Thread
Results 1 to 5 of 5

Alternative of vlookup to find matching data

  1. 06-25-2013, 12:54 PM #1
    abraham30
    abraham30 is offline
    Registered User
    Join Date
    03-07-2013
    Location
    zurich
    MS-Off Ver
    Excel 2010
    Posts
    99

    Alternative of vlookup to find matching data

    Hi,
    I have taken help from this forum previously.

    I want to find the detail desc of case_num from sheet 'logas' when the ID is matching with the ID from sheet 'rush'

    I have created one column and use vlookup function to get the output.

    Without inserting column, is there any alternative way when i double click on any case_num from sheet 'logas' , automatically the output is displayed if it is matching.

    If I select 'PHFR2012GB006089', the output to be show--Case number PHFR2012GB006089 is a spontaneous initial report received from a PATIENT
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-25-2013, 01:04 PM #2
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Alternative of vlookup to find matching data

    Maybe something like this:

    Please Login or Register  to view this content.
    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 06-25-2013, 01:16 PM #3
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Alternative of vlookup to find matching data

    Hi Abraham,

    Try this: Abraham.xlsm
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  4. 06-25-2013, 01:39 PM #4
    abraham30
    abraham30 is offline
    Registered User
    Join Date
    03-07-2013
    Location
    zurich
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Alternative of vlookup to find matching data

    Thank you everyone
    Reply With QuoteRegister To Reply
  5. 06-25-2013, 02:08 PM #5
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Alternative of vlookup to find matching data

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1