+ Reply to Thread
Results 1 to 6 of 6

Values to be returns in main sheet with including Task, Item references in vertical view.

  1. #1
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    Values to be returns in main sheet with including Task, Item references in vertical view.

    Hi,

    I have a workbook in that two work sheets are available one is main sheet therein contains three columns, second is working sheet therein contains six columns, i need a formula for values to be return in main sheet column C from working sheet Column C & F as based on there Task & Item Reference numbers.


    Sample sheet are enclosed.


    Thanks for the help.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Values to be returns in main sheet with including Task, Item references in vertical vi

    Try in C2 then drag down:

    Please Login or Register  to view this content.
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    03-18-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2016 / 2019
    Posts
    251

    Re: Values to be returns in main sheet with including Task, Item references in vertical vi

    Hi,

    C2
    =IFERROR(INDEX('Working Sheet'!$C$3:$C$6,MATCH(1, (A2='Working Sheet'!$A$3:$A$6)*(B2='Working Sheet'!$B$3:$B$6),0)), INDEX('Working Sheet'!$F$3:$F$6,MATCH(1, (A2='Working Sheet'!$D$3:$D$6)*(B2='Working Sheet'!$E$3:$E$6),0)))

    Ctrl-Shift-Enter and copy down
    Last edited by bluesky63; 09-24-2020 at 03:13 AM.
    Christopher Yap

  4. #4
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    Re: Values to be returns in main sheet with including Task, Item references in vertical vi

    Thanks to all for the formula,


    and also i am looking a formula for main sheet Column A & B return the task & Item reference numbers from working sheet column A,B and D,E.



    Thanks,

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Values to be returns in main sheet with including Task, Item references in vertical vi

    Try in A2:

    Please Login or Register  to view this content.
    B2:

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    Re: Values to be returns in main sheet with including Task, Item references in vertical vi

    Thanks for the help,

    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. [SOLVED] Copying entire sheet including code and name references
    By _bells in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2015, 01:51 AM
  2. View formula values instead of cell references
    By Antony S in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-27-2014, 12:34 PM
  3. [SOLVED] Linking Returns for Last "n" values in a column not including blanks
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2013, 05:30 PM
  4. Replies: 1
    Last Post: 10-23-2012, 12:08 AM
  5. Send outlook task from Excel sheet (including the excelsheet)
    By Jop_4444 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-08-2012, 05:26 PM
  6. Replies: 2
    Last Post: 04-23-2009, 11:08 PM
  7. Creating absolute references including active sheet name in the formula
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2005, 04:06 AM

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