+ Reply to Thread
Results 1 to 4 of 4

IF Value from one column matches current column then insert text

  1. 04-16-2021, 11:15 AM #1
    Rick187
    Rick187 is offline
    Registered User
    Join Date
    03-29-2021
    Location
    London
    MS-Off Ver
    M365
    Posts
    2

    IF Value from one column matches current column then insert text

    Hi,

    In Sheet1, Column E I have a list of 3,000 URL's

    In a separate sheet called "Confirmed" in Column G, I have 1,500 of those URL's (so half of them)

    In Sheet 1 Column F, If the URL from Column E is contained in the list of URL's in the separate sheet called "Confirmed", I would like the value of the cell in column F to say "Yes", if the URL is not in the other sheet called "Confirmed", I would like the value to display "No".

    Does anyone know which formula I should be using for this?

    I've tried the following already:

    =IF(Confirmed!G:G='Sheet1'!E2,"yes","no") but it just says "#SPILL!"

    Any help on this would be appreciated.

    Thanks
    Reply With QuoteRegister To Reply
  2. 04-16-2021, 11:21 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,717

    Re: IF Value from one column matches current column then insert text

    Try this:

    =IF(ISERROR(MATCH('Sheet1'!E2,Confirmed!G:G,0)),"no","yes")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-16-2021, 12:48 PM #3
    Mgc26133
    Mgc26133 is offline
    Registered User
    Join Date
    11-13-2018
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    91

    Re: IF Value from one column matches current column then insert text

    I've created a sample excel (of 30 URLS). Let me know if that helps.

    If the default TRUE/FALSE doesn't work for you, you can add an IF function to get "Yes/No" instead.
    Attached Files Attached Files
    Last edited by Mgc26133; 04-16-2021 at 01:46 PM.
    Reply With QuoteRegister To Reply
  4. 04-17-2021, 01:20 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,717

    Re: IF Value from one column matches current column then insert text

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

    Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] INDEX on a cell in Column H if field $A4 matches Column D *OR* Matches Column E?
    By StevenCranford in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2017, 09:05 PM
  2. [SOLVED] If text in column A matches text in column B then use data from column C
    By kemble in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-08-2016, 02:03 PM
  3. Sum values in column D for rows that in column A partially matches a text
    By simone77 in forum Excel General
    Replies: 4
    Last Post: 10-30-2015, 07:59 AM
  4. If A matches B then insert in column C
    By Supersadie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-23-2013, 07:17 AM
  5. Lookup value by choosing column that matches current month
    By Ruthie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2013, 12:35 PM
  6. Lookup value by choosing column that matches current month
    By Ruthie in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-19-2013, 11:32 AM
  7. If cell matches any value in Column insert value in adjacent column
    By de-zoet in forum Excel General
    Replies: 5
    Last Post: 02-24-2012, 06:04 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1