SHEET 1
A1 = NEW JOB NUMBER"
B1 = CAN BE A NEW VALUE ENTERED HOWEVER IF VALUE A1 EXISTS ANYWHERE ON
SHEET 2 IN COL A. NOTE MULTIPLE IDENTICAL ENTRIES MAY OR MAYNOT EXIST
IN COL A SHEET 2.

THEN

IF A1 EXISTS on SHEET 2 THEN B1 SHEET 1 = VALUE IN SHEET 2, COLUMN B TO
RIGHT OF LOOKED VALU. VLOOKUP DOESN't DO IT.

ANY HELP IN WRITING A ROUTINE THAT WILL ALLOW
1) Value to be ENTERED on SHEET 1 COL B1 if A1 VALUE DOES NOT EXIST IN
COLUMN A SHEET 2.OTHERWISE ALLOW USER TO MAKE AN ENTRY IN SHEET 1 B1.

HOPE I'M CLEARER THAN MUD.

IF NOT PLS SOMEONE GIVE ME A TEL AND I WILL CALL YOU TO EXPLAIN IN
GREATER DETAIL MY PROBLEM

REGARDS

RON