# SolvedExcel 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

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

0004 Workstations
0004 Workstations

Sheet3
V W

0001
0001
0001
0004
0005

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

#### etaf

Wayne
Moderator
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

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

#### etaf

Wayne
Moderator
you are welcome

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.

As Seen On