View Single Post
  #1   Report Post  
James
 
Posts: n/a
Default Vlookup of an if statement return

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