Instead of just using "Overdue" in your IF formulas, I recommend you include
some sort of Account Number code, like "Overdue12345", and then do the
VLOOKUP on that code...........

Vaya con Dios,
Chuck, CABGx3


"James" wrote in message
...
Hey all,

Ok here is what I am trying to do.

I have a sheet that in the first column I have an "if" statement that will
either level the blank empty or return the value "Overdue"

On a second sheet I want to be able to use VLookup or a similar function
to
be able to check column "a" on my first sheet for all references to
Overdue
and return the corrosponding value in column "b".

The problem I am having is that I can find the first "Overdue" and get my
column "b" text but I want to set it up to go on and find the next one
and
then the next.

If this is not clear enough let me know and I will try to provide more
information.
--
James