Put this in D3:

=IF(G4="","",INDEX(Sheet2!C1:C100,MATCH(G4,Sheet2! B1:B100,0)))

and this in K3:

=IF(G4="","",INDEX(Sheet2!A1:A100,MATCH(G4,Sheet2! B1:B100,0)))

If you put a job# in G4 that is not in B1:B100 of the other sheet then
you will get a #N/A error.

Hope this helps.

Pete

On Jan 28, 3:32*pm, SHARON wrote:
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