Hi,

You can enter a formula in a cell in Sheet 2 col A which refers to Col B
of Sheet 1.

For eg. enter this formula in Cell A2 of Sheet 2 "=Sheet1!B2" and this
will automatically update the value in sheet 2 column A based on the
values in sheet 1 column B.

Govind.

Steved wrote:
Hello from Steved

I've two identical worksheets Labeled Sheet1 and Sheet2

Sheet1 ColB, ColC, ColD

Sheet2 ColA, ColB, ColC

How do I write a formula Please to update sheet2 ColA
from Sheet1 ColB,

Sheet1 ColC, ColD Are the same Values in Sheet2 ColB, ColC

Thankyou.

Thanks Govind.

I was looking for a lookup formula because sheet1 starts
in row 10 The next line of information is several lines
down ie Row 20. In Sheet2 I have the information starting
in Row 1 then row 2 and row 3 and so on down.

Thankyou.

-----Original Message-----
Hi,

You can enter a formula in a cell in Sheet 2 col A which
refers to Col B
of Sheet 1.

For eg. enter this formula in Cell A2 of Sheet 2 "=Sheet1!
B2" and this
will automatically update the value in sheet 2 column A
based on the
values in sheet 1 column B.

Govind.

Steved wrote:
Hello from Steved

I've two identical worksheets Labeled Sheet1 and Sheet2

Sheet1 ColB, ColC, ColD

Sheet2 ColA, ColB, ColC

How do I write a formula Please to update sheet2 ColA
from Sheet1 ColB,

Sheet1 ColC, ColD Are the same Values in Sheet2 ColB,
ColC

Thankyou.


.

Okay this is my attempt

=HLOOKUP(B2,Schools Database!C10:C2000,C2,Schools Database!
D10:D2000)

in Sheet1 I've Labeled it Schools Database
In Sheet2 I've Labeled it Data Sort

the above Formula is in A2 What have I missed please.

Thankyou.


-----Original Message-----
Thanks Govind.

I was looking for a lookup formula because sheet1 starts
in row 10 The next line of information is several lines
down ie Row 20. In Sheet2 I have the information starting
in Row 1 then row 2 and row 3 and so on down.

Thankyou.

-----Original Message-----
Hi,

You can enter a formula in a cell in Sheet 2 col A which
refers to Col B
of Sheet 1.

For eg. enter this formula in Cell A2 of Sheet
2 "=Sheet1!
B2" and this
will automatically update the value in sheet 2 column A
based on the
values in sheet 1 column B.

Govind.

Steved wrote:
Hello from Steved

I've two identical worksheets Labeled Sheet1 and Sheet2

Sheet1 ColB, ColC, ColD

Sheet2 ColA, ColB, ColC

How do I write a formula Please to update sheet2 ColA
from Sheet1 ColB,

Sheet1 ColC, ColD Are the same Values in Sheet2 ColB,
ColC

Thankyou.


.

.