I am trying to create a formula....

In worksheet 2 I have a listing with 3 columns labeled "area" "job #" and
"name" in columns a, b, and c respectively with over 100 rows.

In worksheet 1 I have a form where I want to be able to type the "job #" in
a cell G4, and i want it to automatically fill in the "name" in cell d3, and
to automattically fill in the "area" in cell k3.

I believe this is an if/then statement, however i can't get it to work. Any
help is greatly appreciated.
--
Thanks,
Sharon