Hi,
I have a countif formula that works. It shows me the amount of time past since a certain date, but what i need to to know what row it refers to so i can do something like a vlookup and pull other data from that row that is in different columns. I'll want about 3 different columns including a unique reference.
So for example, when my countif formula finds 5 matches, i would like to know the found matches; Job number, raised date, due date etc.
How can i do this?
TIA
I have a countif formula that works. It shows me the amount of time past since a certain date, but what i need to to know what row it refers to so i can do something like a vlookup and pull other data from that row that is in different columns. I'll want about 3 different columns including a unique reference.
So for example, when my countif formula finds 5 matches, i would like to know the found matches; Job number, raised date, due date etc.
How can i do this?
TIA