I have two questions.

First,
See the below data.

123456 BOOKA
234555 BOOKB
345678 BOOKC
848599 BOOKD
111100 BOOKE
758844 BOOKF
877290 BOOKG
585858 BOOKH

I want : When I type 123456 in a cell, the cell will be changed to BOOKA
automatically. When I type 234555, the cell will be changed to BOOKB.........
How can do this request using IF fuction or vLOOKUP

Question 2.

How can I use IF or other functions to do ........

I have data in cell A1 (123456), and B1 (500pcs)
now, I would like to use IF or other functions to set that If A1 =123456 and
B1= 500pcs, C1 would be shown 20KGS automatically.

--
wuwu