+ Reply to Thread
Results 1 to 4 of 4

extracting info from one cell based on info from other cells

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Stavanger
    MS-Off Ver
    Office 365
    Posts
    39

    extracting info from one cell based on info from other cells

    Hi,
    I want to be able to retreive information based on values in other cells.
    I'm calculating m2 surface for different types of pipes and steel.
    Attached there's an example.

    If I type HEB in column C, 100 in Column D I want it to give me the number 0,567 automatically from column L in column G.

    Is that possible? This will apply to houndres of various types so it would save me a lot of time.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,208

    Re: extracting info from one cell based on info from other cells

    It will be easier if you have TYPE down ROWS and DIM across COLUMNS

    See attached:

    in G6


    =INDEX($O$7:$Z$100,MATCH($C6,$N$7:$N$100,0),MATCH($D6,$O$6:$Z$6,0))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-12-2012
    Location
    Stavanger
    MS-Off Ver
    Office 365
    Posts
    39

    Re: extracting info from one cell based on info from other cells

    Perfect!! Thank you :D

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,208

    Re: extracting info from one cell based on info from other cells

    You are welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    Beat me to it!
    Last edited by JohnTopley; 02-16-2017 at 04:12 AM. Reason: Arleady marked as SOLVED

+ 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. Extracting info from cell
    By viber52 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2015, 09:42 PM
  2. this is a hard one... Extracting info from raw data based on list of criterion
    By xcelnoob77 in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 04-07-2014, 04:12 AM
  3. Replies: 4
    Last Post: 10-02-2013, 03:00 PM
  4. Replies: 5
    Last Post: 06-01-2012, 05:04 PM
  5. Extracting conditional based info Vlookup
    By ragavendraph in forum Excel General
    Replies: 5
    Last Post: 02-27-2012, 12:09 PM
  6. Coloured cells based on other cell info
    By Nightshift86 in forum Excel General
    Replies: 4
    Last Post: 05-20-2010, 02:42 AM
  7. Replies: 1
    Last Post: 02-21-2006, 10:30 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