redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
I'm having trouble getting a simple VLOOKUP to return a time value
Simple data is shown below
so D1 is the time value between C1 and B1, I simple want the Value of D1 (03:02 in this example) to be searched in the table
E1 should bring back the time value of 00:30 but I'm getting the #N/A error
any help appreciated, assume its how I have the data stored but can't figure out what to do
]
Thanks
I'm having trouble getting a simple VLOOKUP to return a time value
Simple data is shown below
Overtime.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
1 | 05:58 | 09:00 | 03:02 | #N/A | 03:00 | 00:00 | ||||
2 | 03:01 | 00:15 | ||||||||
3 | 03:02 | 00:30 | ||||||||
4 | 03:03 | 00:45 | ||||||||
5 | 03:04 | 01:00 | ||||||||
6 | ||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | D1 | =C1-B1 |
E1 | E1 | =VLOOKUP(D1,H1:I5,2,FALSE) |
so D1 is the time value between C1 and B1, I simple want the Value of D1 (03:02 in this example) to be searched in the table
E1 should bring back the time value of 00:30 but I'm getting the #N/A error
any help appreciated, assume its how I have the data stored but can't figure out what to do
]
Thanks