+ Reply to Thread
Results 1 to 4 of 4

Formula (Index?) to pull data from one sheet to another based on cell data

  1. #1
    Registered User
    Join Date
    02-04-2021
    Location
    California
    MS-Off Ver
    365 E3
    Posts
    8

    Formula (Index?) to pull data from one sheet to another based on cell data

    Hello,

    I am pretty comfortable with excel formulas but INDEX and MATCH I have never gotten to know very well and think they are what I need here.
    In my sample workbook I have two tabs ("NS" and "SAS") where I have listed project tickets in Column A . What I want is that when the Ticket is updated to 'Yes' in column C (titled Approved), that the Ticket will automatically appear on the third tab titled 'Approved'. The end goal is to update the ticket's approval status in the NS and SAS tabs, and have them automatically show on the list of tickets on the Approved tab.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    725

    Re: Formula (Index?) to pull data from one sheet to another based on cell data

    Try in A2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

  3. #3
    Registered User
    Join Date
    02-04-2021
    Location
    California
    MS-Off Ver
    365 E3
    Posts
    8

    Re: Formula (Index?) to pull data from one sheet to another based on cell data

    perfect, thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    725

    Re: Formula (Index?) to pull data from one sheet to another based on cell data

    You're welcome. Glad to help.
    Thanks for the feedback and for the reputatioon added.
    Have a blessed evening!

+ 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] Pull data from one sheet to another based on cell value
    By kv.singh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2020, 02:56 PM
  2. need vba to pull data from another sheet based on cell input
    By anuwers in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-29-2020, 02:03 PM
  3. Complex Index/match formula to pull data based on 1 criteria. (Bid/Cost Sheet)
    By Blackmagic42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2019, 01:45 AM
  4. Replies: 0
    Last Post: 03-30-2016, 09:08 PM
  5. Formula to pull data from one sheet to a new sheet based on date range
    By lisajolley11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2015, 08:38 PM
  6. Pull data from multiple sheets based on cell in Main sheet
    By cpyter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2014, 01:19 PM
  7. Replies: 3
    Last Post: 01-27-2013, 07:23 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