+ Reply to Thread
Results 1 to 3 of 3

Google Sheet - If Find Match from Import Range then Add Status

  1. #1
    Registered User
    Join Date
    07-25-2015
    Location
    USA
    MS-Off Ver
    MS Office 2020
    Posts
    33

    Google Sheet - If Find Match from Import Range then Add Status

    Hello expert,

    I have a google sheet that I want to find and match data from importrange, if match add status.
    Here's google sheet link for edit: https://docs.google.com/spreadsheets...kMA/edit#gid=0

    SETUP
    There are 3 tabs. MAIN tab I own and hope to combine all data here.
    Complete and Pending tab are importrange controlled by someone else.

    NEED
    In A2 down, I want to fill with status label if C2 down is found and match in Complete or Pending tab. (eg. C2 job id is gggw, found in Pending tab, so A2 will fill "pending")

    Thank you so much in advance!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Google Sheet - If Find Match from Import Range then Add Status

    Does this works?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by zbor; 03-07-2017 at 03:11 PM.

  3. #3
    Registered User
    Join Date
    07-25-2015
    Location
    USA
    MS-Off Ver
    MS Office 2020
    Posts
    33

    Re: Google Sheet - If Find Match from Import Range then Add Status

    @zbor YOU'RE AWESOME!! THANKS!!

+ 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. Import Access query results into Excel show import status
    By mwatson4788 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2016, 10:12 AM
  2. Import from Google Docs
    By www.vyuka-excelu.cz in forum Excel General
    Replies: 0
    Last Post: 07-22-2015, 11:30 AM
  3. [SOLVED] Find The Match For All The Cells From A Range In Another Sheet And Use Their Color
    By taccoo73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2014, 10:45 AM
  4. Range.Find function fails to find a match but For loop confirms that match exists
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2013, 03:35 PM
  5. [SOLVED] Import Excel Data to Find Match in Access Table
    By CRW in forum Access Tables & Databases
    Replies: 3
    Last Post: 09-15-2012, 08:11 AM
  6. Find Last Status in Range
    By mycon73 in forum Excel General
    Replies: 4
    Last Post: 07-21-2011, 09:23 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