+ Reply to Thread
Results 1 to 5 of 5

Looking formula from other sheet and specific column

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010,2007
    Posts
    96

    Looking formula from other sheet and specific column

    hi all expert,

    I want to fill in the numbers 1 to 5 in the "F" column as per my wish. And in column G, it contains data from the "lookup" sheet based on column F and column RO from sheet "COM". (sample data - attached).

    kindly help to formula information . thank you


    regard

    Dolphino
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: Looking formula from other sheet and specific column

    Try his, copied down...
    =INDEX(lookup!$E$2:$E$31,MATCH(COM!F4&" "&COM!C4,INDEX(lookup!$D$2:$D$31&" "&lookup!$B$2:$B$31,0),0))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,664

    Re: Looking formula from other sheet and specific column

    Please try at G4

    =SUMIFS(lookup!$E$2:$E$31,lookup!$B$2:$B$31,C4,lookup!$D$2:$D$31,F4)
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010,2007
    Posts
    96

    Re: Looking formula from other sheet and specific column

    dear FDibbins & Bo_Ry

    thank you for your instruction, the all formula running correctly.

    Regard.

    Dolphino

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: Looking formula from other sheet and specific column

    Happy to help and thanks for the feedback

+ 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. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  2. Move row data to a specific sheet if column contains specific word
    By Kennethc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 06:55 PM
  3. [SOLVED] Trying to move specific range to a specific sheet based on data in certain column
    By cain2011 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-01-2013, 08:09 AM
  4. [SOLVED] Populate summary sheet with values within specific month column on data sheet...
    By blue91 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2013, 12:11 PM
  5. Extract specific column data from specific sheet from multiple files in a folder
    By piggyfox in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2013, 11:51 AM
  6. Replies: 10
    Last Post: 03-31-2013, 07:40 PM
  7. Replies: 4
    Last Post: 11-02-2012, 04:14 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