Hi everybody,
I've been asked to see if this is possible, and Vlookup is the only way I can think of off the top of my head.
What I need to do is this.
I have 2 tables. In table 1, I have incident dates, and builders assigned, on 1 line.
In table 2, I have an XY table, with Builders, Reporting periods, and ranks. E.g.
-----------Period1--Period2
Builder 1--Gold----Silver---
What I need to do is lookup the builder and incident date in table 1, and match it to the rank for the period that date corresponds to.
For example. On 12/Jan/2008, Builder 1 was assigned to a job. 12/Jan/2008 is within period 2 (Nov 07-Jan 08), so the function should return "Silver"
I'm pretty sure this is going to be a bit more complex than a simple VLookup, potentially combining functions (Maybe matching a Vlookup and a HLookup?) but I'm not sure where to start. Your assistance and expertise is greatly appreciated.
-Bob
Edit: After some experimenting, A Vlookup combined with a Match is working fine, I just need to figure out how to format my dates. For example, how do I match 01/01/08 with "01/11/2007-31/01/2008"?
Bookmarks