1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved Excel Mac 2011 - Functions - IF statement

Discussion in 'Business Applications' started by duvdevan, Dec 16, 2016.

Thread Status:
Not open for further replies.
Advertisement
  1. duvdevan

    duvdevan Thread Starter

    Joined:
    Dec 16, 2016
    Messages:
    2
    I have 2 sheets on my workbook what I want to do is compare (Sheet2)C = (Sheet3)V and if the result is true then copy (Sheet2)D text into (Sheet3)W.

    =IF(V2=Sheet3!C2, Sheet3!D2, "") but the result I had is always FALSE or ""

    [​IMG]

    Columns C and V are numbers

    Sheet2
    C D

    0001 Computadoras de Escritorio
    0001 Computadoras de Escritorio
    0004 Workstations
    0004 Workstations
    0005 Servidores para computadora


    Sheet3
    V W

    0001
    0001
    0001
    0004
    0005

    I don't know how to solve this so any help will be appreciated.

    thank you in advance
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
    you said Sheet2!C = Sheet3!V

    where have you put that formula ?

    in sheet3!W2
    PUT
    =IF( Sheet2!C2 = Sheet3!V2 , Sheet2!D2, "")

    If you are getting false
    to check
    try a couple of cells where you know they match and
    in a cell put
    Sheet2!C? = Sheet3!V?

    you may have hidden characters in some of the cells

    00001
    has that been specially formatted
    a number would return 0
    or text
    00001

    otherwise attach a sample spreadsheet here
     
    duvdevan likes this.
  3. duvdevan

    duvdevan Thread Starter

    Joined:
    Dec 16, 2016
    Messages:
    2

    Wayne

    thank you for your help, you're right the values of one of the columns was text but once I converted them to integer it works.

    thank you again
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
    you are welcome
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1182518

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice