+ Reply to Thread
Results 1 to 4 of 4

Extract data using 3 cell references

  1. #1
    Registered User
    Join Date
    02-01-2018
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    18

    Extract data using 3 cell references

    Hi all,

    In the attached image, my inputs are in columns A to J.
    I need to check the cells H1, I1 and J1 in A:B and its corresponding values in D,E,F have to be filled in K1,L1 and M1.
    In this way, the rest will follow.

    Can you please derive an formula to make this.

    DATA.PNG


    Thanks,
    Prabhu P

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Extract data using 3 cell references

    Try this in K1:

    =INDEX(D$1:D$4,MATCH($H1&$I1&$J1,$A$1:$A$4&$B$1:$B$4&$C$1:$C$4,0)) Ctrl Shift Enter

    Drag to the right and down.

  3. #3
    Registered User
    Join Date
    02-01-2018
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    18

    Re: Extract data using 3 cell references

    HI, that worked perfectly....

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Extract data using 3 cell references

    Happy to help. Thanks for the rep!

+ 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: 7
    Last Post: 09-07-2017, 05:15 AM
  2. References Double extract the last
    By Berna11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-16-2016, 02:00 PM
  3. Can a Macro extract cell references from a Column and paste them into a Row.
    By Waste Timer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2016, 11:51 PM
  4. Using cell references to construct data ranges in chart data selection
    By rmalliston in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2016, 08:48 PM
  5. [SOLVED] How do I sort and extract unique entries from multiple references
    By sherlock99 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2014, 08:01 AM
  6. Replies: 0
    Last Post: 02-11-2013, 08:12 AM
  7. [SOLVED] How to rename references from range names to cell references
    By Abbas in forum Excel General
    Replies: 1
    Last Post: 05-24-2006, 01:25 PM

Tags for this Thread

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