| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
| How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Threaded Mode
