Telling us "i can't get it to work" doesn't give us much to go on. You'll
get much better help if you show us what formula you tried.

In this case, I suspect you want a Vlookup statement. Something like:

d3: =vlookup(g4,sheet2!A:C,2,false)
k3: =vlookup(g4,sheet2!A:C,3,false)

Rearrange your columns on worksheet 2 to have job # first, then area, then
name.

Regards,
Fred.

"SHARON" wrote in message
...
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