Formula between worksheet tabs

[Sam]

I have two tabs in a workbook. I have accounts in column A on worksheet 1
(editorial). I want to search the account column A on worksheet 2
(planning_nodes) and if the account matches account from worksheet 1, I want
it to bring back the data from column C in worksheet 2 (planning_nodes). I
tried using an If formula.

=IF(A2=planning_nodes!A:A,planning_nodes!C:C,"")

This formula is not working. Is there a better formula?

Thanks

 

[T. Valko]

Try this:

=VLOOKUP(A2,planning_nodes!A:C,3,0)

 

[Mike H]

Try

=VLOOKUP(A2,'Planning nodes'!A:C,3,FALSE)

Mike

 

[Sam]

That worked. Thanks.

Try

=VLOOKUP(A2,'Planning nodes'!A:C,3,FALSE)

Mike