Have a formula question, I think it is a if formula?

[DelageL18]

I have a document and it has 3 pages; on page 2 it has accounts in
column D and on page 3 it has accounts in colum D. I think this is pretty easy but it is given me a pain.


Example: If on page 2 the account # is 123456-1234 then on page 3 I want it to say 987654-001-1234.

[oldchippy]

I have a document and it has 3 pages; on page 2 it has accounts in
column D and on page 3 it has accounts in colum D. I think this is pretty easy but it is given me a pain.


Example: If on page 2 the account # is 123456-1234 then on page 3 I want it to say 987654-001-1234.

Go to page 3, click the cell, then click page 2 tab, then the cell with 123456-1234 in it, then Enter. What ever you type on page two in that cell is automatically reproduced on page 3.

[Carim]

Hi,

Your question looks a bit mysterious to me ...
Are you looking for the function VLOOKUP() ... ? ( press F1 for details )

HTH
Carim