Problem with if formulae

[carrach]

Hi,
I need to copy info from 'sheet1!columnJ' into 'sheet2!columnO', if the data in sheet1!columnA matches the data in sheet2!columnA.
in cell O2 in sheet 2 I tried:
=if((new_clients_company_name=C3),new_clients_postcode," ")

please note that new_clients_company_name is sheet1 column A.
new_clients postcode is sheet1 column J.

my formulae did not work at all and just sat in the cell doing nothing. What am I doing wrong?
Grateful for any help
many thanks
carrach

[Domski]

No really a programming question but anyway...

Do you mean you have a table on Sheet 1 that you want to look up the value from Sheet 2 column A and return the respective post code?

If I've understand correctly you would use VLOOKUP rather than an IF formula.

Dom

[foxguy]

Hi,
I need to copy info from 'sheet1!columnJ' into 'sheet2!columnO', if the data in sheet1!columnA matches the data in sheet2!columnA.
in cell O2 in sheet 2 I tried:
=if((new_clients_company_name=C3),new_clients_postcode," ")

please note that new_clients_company_name is sheet1 column A.
new_clients postcode is sheet1 column J.

my formulae did not work at all and just sat in the cell doing nothing. What am I doing wrong?
Grateful for any help
many thanks
carrach

Your formula doesn't match your description. Where did C3 come into the picture?
I think you are trying to do this. Find the row in Sheet1!Column A that has the company in C3, and then get the code from Sheet1!Column J for that row.
O2 : =Index(new_clients_postcode,match(C3,new_clients_company_name,0),1)
It could also be accomplished like Dom says
O2 : =VLookup(C3,Sheet1!$A:$J,10,FALSE)