I have a sample of what i CAN NOT solve ... Thanks a lot!

Sheet1:
Code Description Number
Code1 Description1 Number1
Code2 ................ ...........
.....
...


Sheet2
Code Description Number

Now:
Exp: Row 4 (First Code B-column = B4)
B4(Code)=Read a Code from BarCode Reader (auto entry)

C4(Description)=(I need to check what data have in Code - B4 (auto entry), search for that data in Code (Columnn-B from Sheet1) and when find the same mach, I want to bring tha data from the same row from (Columnn-D from Sheet1) Description (Exp: If BarCodeReader at B4 read Number 15, then I want C4 to show Description15 (from Sheet1)

D4(Number)=(I need to check what data have in Description - C4, search for that data in Description (Columnn-C) from Sheet1 and when find the same mach, I want to bring tha data from the same row from (Columnn-D) Number (Exp: If Description become Description15 (at C4) than in the D4 I want to have Number15 (from Sheet1 )