Hello from Steved

Below is giving me a 0 value Why please it should be a 4
digit number.

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



-----Original Message-----
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.

.