Im just going to start with the tables that will help show what i am trying to do...
TABLE 1
File # Date id
2 15 ?
2 11 ?
2 7 ?
2 6 ?
TABLE 2
File # Start Stop id
2 9 13 1
2 14 16 2
2 1 8 3
Ok so say i have these two tables...i want to be able to look at the file # of line 1 in table 1, go to table 2 and return the id where the date from table 1 is between the start and stop in table 2. ie...in that example it should return id "2"
Ive been playing with vlookup to do this, but have gotten no where because it just takes the first match it finds. Any help will be greatly appreciated
thnx in advance
-reilly
Bookmarks