=if or not?

[Guest]

Hello,

Immediately below is a report I need to export into another report. Sheet
1: Column A shows the date, Column B shows the time frame, you can ignore
column C, Column D shows the number of calls that came in during Column B’s
timeframe and Column E shows the number of abandoned calls.

Sheet 1
A B C D
E
Date Time Collated Time Answered Calls Abandoned Calls
8/29/2004 7:00:00 1800 0 0
8/29/2004 7:30:00 1800 0 0
8/29/2004 8:00:00 1800 2 0
8/29/2004 8:30:00 1800 2 0
8/29/2004 9:00:00 1800 9 0
8/29/2004 9:30:00 1800 5 0
8/29/2004 10:00:00 1800 4 0
8/29/2004 10:30:00 1800 9 1
8/29/2004 11:00:00 1800 5 1
8/29/2004 11:30:00 1800 7 0

What I need to do is bring the data from sheet 1 into sheet 2. For example
if the Sheet 1 column B matches Sheet 2 column B then the date will be
brought over to column A, Answered calls will be brought over for column c,
etc…

Now an =if may work but keep in mind that the data from sheet 1 will not
always be in the same cell. The location of the data on sheet 1 does vary
from day to day.

Sheet 2
A B C D
E
Date Time Answered Calls Abandoned Calls Offered Calls
7:00:00
7:30:00
8:00:00
8:30:00
9:00:00
9:30:00
10:00:00
10:30:00
11:00:00
11:30:00

Thanks for the help!!!

 

[Guest]

You can use a combination of MATCH and INDEX to get the corresponding data
from sheet1.
Ex: in Sheet2!A2: =index(Sheet1!A:A, match($B2,Sheet1!$B:$B,false)).
That effectively finds the row number in sheet1 with the matching time, then
returns the corresponding entry from column A in sheet1. You could copy this
formula into other rows/columns of your table, but in C2, D2 and E2, you'll
need to adjust the first column reference (Sheet1!A:A) to pick up the
appropriate column.