IF command looking at a reference...
Hi, i'm trying to create an adherence report based on logged in time of an advisor on the phone. In one cell I have their logged on time which is a VLOOKUP from another sheet. I want to use this value to trigger another cell to show their scheduled logged in time
So...
If cell A1 = 06:39:42 (actual logged in time lookep up from another sheet), I want cell F1 to show 07:30:00 if there is a value in A1. If A1 is blank, i want F1 to show blank...
I've tried with IF but I think the VLOOKUP is fudging it..
Thanks in advance.
Neil
|