+ Reply to Thread
Results 1 to 9 of 9

Formula to Lookup Corresponding Data and Return a Value

  1. 10-14-2014, 08:29 PM #1
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Formula to Lookup Corresponding Data and Return a Value

    Hi Folks

    Sample Sheet attached.

    Cheers
    Hammer
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-14-2014, 11:54 PM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Formula to Lookup Corresponding Data and Return a Value

    May be this.....

    In G3 
    Please Login or Register  to view this content.
    and copy down.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 10-15-2014, 12:00 AM #3
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Formula to Lookup Corresponding Data and Return a Value

    hi, Refer the formula in the attachment
    Attached Files Attached Files
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  4. 10-15-2014, 12:08 AM #4
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Formula to Lookup Corresponding Data and Return a Value

    Hi ,

    Just for knowledge with the help of + Index + Match + Indirect + Array

    =
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Punnam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 10-15-2014, 12:18 AM #5
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to Lookup Corresponding Data and Return a Value

    Champion efforts!

    Thanks to you both for your time-much appreciated.

    Hammer
    Reply With QuoteRegister To Reply
  6. 10-15-2014, 12:20 AM #6
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to Lookup Corresponding Data and Return a Value

    And now to Punnam too
    Reply With QuoteRegister To Reply
  7. 10-15-2014, 12:25 AM #7
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Formula to Lookup Corresponding Data and Return a Value

    hammer2

    Thanks for the feedback & Reputation

    Punnam
    Reply With QuoteRegister To Reply
  8. 10-15-2014, 12:35 AM #8
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Formula to Lookup Corresponding Data and Return a Value

    Here is your Formula..
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Check the attached file..



    Edit:- I got late..
    Attached Files Attached Files
    Last edited by Vikas_Gautam; 10-15-2014 at 12:37 AM.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  9. 10-15-2014, 12:41 AM #9
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Formula to Lookup Corresponding Data and Return a Value

    Hi, Thanks for the rep and feedback
    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)

Similar Threads

  1. [SOLVED] Not sure how to return the data from a lookup
    By ktkreeger in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-30-2013, 01:34 PM
  2. [SOLVED] Formula to lookup a range of numbers and then return data in next 2 columns
    By justmeok in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-15-2013, 11:54 PM
  3. lookup formula to return data where column header matches
    By tim-harrison in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2013, 12:58 AM
  4. Excel 2007 : Formula to return an address from a lookup, not a value
    By 25609thStreet in forum Excel General
    Replies: 4
    Last Post: 11-03-2010, 02:33 PM
  5. How to lookup a value and return a formula?
    By fivepairs in forum Excel General
    Replies: 13
    Last Post: 04-06-2009, 04:49 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