View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Twiggy Twiggy is offline
external usenet poster
 
Posts: 10
Default Matching call data based on date, time and number called to give c

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