Solved Excel Mac 2011 - Functions - IF statement

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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 ""



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
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,490
want to do is compare (Sheet2)C = (Sheet3)V

V2=Sheet3!C2
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

Thread Starter
Joined
Dec 16, 2016
Messages
2
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

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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Members online

Top