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

Hi!

That can't be done.

You would have to let the user enter the new value in another cell. A cell
can contain two types of entries: a formula or a constant (a value entered
manually) but not both.

You said:

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.

Vlookup should be able to do that. Maybe post back with more specific
details.

Biff

"Ronald Cayne" wrote in message
...

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