T
Twiggy
I have the following two tables on different sheets, both containing other
information within them that is irrelevant in my question.
SHEET 1
Date - Time - Number Called Duration Cost
01/02/10 09:05:21 01234123456 02:16 0.50
SHEET 2
Date - Time Number Called - Duration Extension
01/02/10 09:07:56 01234123456 02:15 1234
01/02/10 15:30:45 01234123456 01:59 1234
Sheet 2 HAS A LOT MORE RECORDS THAN SHEET 1 AND THERE ARE A NUMBER OF CALLS
TO THE SAME NUMBER EACH SAME DAY AT DIFFERENT TIMES DURING THE DAY.
What I am trying to do is add another column on sheet 2, to match that
specific call to the one in Sheet 1 and provide me the cost charged from
Sheet 1. My other problem is that although the date and number dialled are
equal the times and durations are slightly adrift (no more than 4 minutes).
Think I need an if and a vlookup but can anybody assist
Thank you
information within them that is irrelevant in my question.
SHEET 1
Date - Time - Number Called Duration Cost
01/02/10 09:05:21 01234123456 02:16 0.50
SHEET 2
Date - Time Number Called - Duration Extension
01/02/10 09:07:56 01234123456 02:15 1234
01/02/10 15:30:45 01234123456 01:59 1234
Sheet 2 HAS A LOT MORE RECORDS THAN SHEET 1 AND THERE ARE A NUMBER OF CALLS
TO THE SAME NUMBER EACH SAME DAY AT DIFFERENT TIMES DURING THE DAY.
What I am trying to do is add another column on sheet 2, to match that
specific call to the one in Sheet 1 and provide me the cost charged from
Sheet 1. My other problem is that although the date and number dialled are
equal the times and durations are slightly adrift (no more than 4 minutes).
Think I need an if and a vlookup but can anybody assist
Thank you