# Solved Excel Mac 2011 - Functions - IF statement

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

Not open for further replies.

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

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.

2. ### etafModerator

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.

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. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,965
First Name:
Wayne
you are welcome

As Seen On