nikkigotro
New Member
- Joined
- Oct 17, 2013
- Messages
- 6
I am working on a project in Excel 2013 in which I have data on two separate tabs. I am looking at the time stamp that a call was placed in one of our systems and am trying to use a lookup to find the closest corresponding time stamp on the orders data (on the other sheet) and return a unique order number for each call. I can get order numbers to pull over using both an INDEX MATCH and a VLOOKUP, but about 1/3 of my results are duplicates. Any help that I could get would be greatly appreciated!
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
The "Order" Column on the second sheet is the one I am trying to fill in based on approximate data in the first sheet (there should not be any cases where these match exactly). I just need unique order numbers in my second sheet. Also, the very first timestamp produces N/A error because there is not an order with a timestamp that comes in previous to that call. Is there a fix for this as well?
Thank you in advance!!!
Sheet 1
Timestamp | Order | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Sheet 2
Order | Timestamp | |
<tbody> </tbody> | ||
<tbody> </tbody> | ||
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody>
</tbody>
The "Order" Column on the second sheet is the one I am trying to fill in based on approximate data in the first sheet (there should not be any cases where these match exactly). I just need unique order numbers in my second sheet. Also, the very first timestamp produces N/A error because there is not an order with a timestamp that comes in previous to that call. Is there a fix for this as well?
Thank you in advance!!!