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