Hi,
I hope I explain this right but I’m trying to do what I assume is a simple VLOOKUP (although my excel knowledge is limited ?)
I’ve attach two photos, the first 2 show the VLOOKUP formula, that I found online, working with simple numbers.
The second 2 showthe same formula but trying to find it within a range on time and it always returns the same result of 00:15
Can anyone see what I’m doing wrong?…Maybe it can’t be done with a range of time?
Any help much appreciated.
I hope I explain this right but I’m trying to do what I assume is a simple VLOOKUP (although my excel knowledge is limited ?)
I’ve attach two photos, the first 2 show the VLOOKUP formula, that I found online, working with simple numbers.
The second 2 showthe same formula but trying to find it within a range on time and it always returns the same result of 00:15
Can anyone see what I’m doing wrong?…Maybe it can’t be done with a range of time?
Any help much appreciated.