+ Reply to Thread
Results 1 to 9 of 9

if value exist in colum return message..

  1. 04-24-2014, 07:43 AM #1
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    if value exist in colum return message..

    hi All

    I am trying to include a formulae that will check for duplications

    if a value existe on column E then it is a duplicate

    I have tried combining VLOOK up with IF but it is tempremental ..

    =IF(VLOOKUP(D17,' Master report test.xls]Sheet1'!$E:$G,3,FALSE)=#N/A,"OK","Possible Duplicate!")

    any suggestions please ?

    Thanks
    Attached Files Attached Files
    Last edited by bimo; 04-24-2014 at 08:07 AM.
    Reply With QuoteRegister To Reply
  2. 04-24-2014, 07:58 AM #2
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: if value exist in colum return message..

    Hi,

    Can you please upload a sample workbook here?
    Reply With QuoteRegister To Reply
  3. 04-24-2014, 08:07 AM #3
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: if value exist in colum return message..

    added ..Thanks
    Reply With QuoteRegister To Reply
  4. 04-24-2014, 09:05 AM #4
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: if value exist in colum return message..

    If you are willing to sort based on col D, then you can use a simple formula in col E that is =D2-D1 copied down and every place you have a zero you know you have a duplicate.
    If you want it to be blank then say "duplicate" where you have one, write it as an if statement to be =IF(D3-D2>0,"","duplicate") starting in cell E3 and copied down.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  5. 04-24-2014, 09:25 AM #5
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: if value exist in colum return message..

    This might help:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  6. 04-24-2014, 10:35 AM #6
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: if value exist in colum return message..

    good Formulae ..thank you

    However I have over simplified my need..the test actually need to carried out on different sheet.

    I have re uploaded the file if I need to put this through a new thread let me know

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-24-2014, 11:59 AM #7
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: if value exist in colum return message..

    There is nothing in B25 of either worksheet so what do you mean on Duplicate Test by this? "if B25 already exist show duplicate "
    Reply With QuoteRegister To Reply
  8. 04-24-2014, 12:14 PM #8
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: if value exist in colum return message..

    Quote Originally Posted by newdoverman View Post
    There is nothing in B25 of either worksheet so what do you mean on Duplicate Test by this? "if B25 already exist show duplicate "
    users fill in B5 ((sorry not b25) and if value of B5 already exist in sheet1 column D then C5 in sheet "duplicate test"show duplicate message
    Reply With QuoteRegister To Reply
  9. 04-24-2014, 01:37 PM #9
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: if value exist in colum return message..

    If there is an entry for B5 in sheet one, this will indicate Duplicate.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    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] Pop up message box if duplicate exist
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-23-2013, 10:59 AM
  2. Validation error message when data does not yet exist.
    By rodge in forum Excel General
    Replies: 6
    Last Post: 04-09-2012, 02:26 PM
  3. The reference is not valid error message for data - but the same ones appear to exist
    By lightecho in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2012, 01:19 PM
  4. Data may exist in the sheet(s) message
    By cedtech23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2006, 10:15 AM
  5. [SOLVED] Checking that file exist and if not display a message
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 10:20 AM

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