how to find a cell in excel and find all values in a row before that cell

[DAVIDZZZ]

NEED HELP IN CRACKING THE FOLLOWING,

Attachment 456568

FROM THE PICTURE ATTACHED i WOULD LIKE TO DISPLAY THE OUTPUT AUTOMATICALLY, BUT CAN SOMEONE TELL ME HOW?

IF CELLVALUE = 1, THEN
LOOK FOR THE LOCATION OF "A"

IF "A" IS BEFORE "1" THEN
RETURN "EARLY"

ELSEIF "A" IS AFTER "1" THEN
RETURN "LATE"

ELSEIF "A" IS WITHIN 1 (ie, 1=1A) THEN
RETURN "SAME"

ELSE
RETURN "NOT DONE"

PLS HELP

[djbomaha]

Here is a workbook with an event enabled macro for sheet 1 that is an example of what you described.

[DAVIDZZZ]

could u tell me how did u do it?