Formula between worksheet tabs
 

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

Formula between worksheet tabs
 

Try this:

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


--
Biff
Microsoft Excel MVP


"Sam" wrote in message
...
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

Formula between worksheet tabs
 

Try

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

Mike

"Sam" wrote:

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

Formula between worksheet tabs
 

That worked. Thanks.

"Mike H" wrote:

Try

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

Mike

"Sam" wrote:

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