Hi guys,
I am trying to get the amount from one sheet to populate into cells in a second sheet using two criteria from the second sheet:
Rows = Account number
Columns = Dates
The first sheet is a sales log that lists the date, account number, and the amount. I want to use columns with dates to compare against rows with acct numbers from the second sheet to get the amounts. I was going to combine vlookup and hlookup but it started to get ridiculous rather quickly. I've searched around and it looks like index and match would work. But I don't know how to do that with two sheets.
I have attached the example.
Thank you very much for any help you can offer.
Sheet1
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
I am trying to get the amount from one sheet to populate into cells in a second sheet using two criteria from the second sheet:
Rows = Account number
Columns = Dates
The first sheet is a sales log that lists the date, account number, and the amount. I want to use columns with dates to compare against rows with acct numbers from the second sheet to get the amounts. I was going to combine vlookup and hlookup but it started to get ridiculous rather quickly. I've searched around and it looks like index and match would work. But I don't know how to do that with two sheets.
I have attached the example.
Thank you very much for any help you can offer.
Sheet1
DATE | ACCT | DEBIT |
7/5/2012 | 1 | 63,838.45 |
7/5/2012 | 1 | 51,968.36 |
7/5/2012 | 7 | 26,598.81 |
7/2/2012 | 5 | 26,340.81 |
7/6/2012 | 3 | 25,462.57 |
7/2/2012 | 8 | 25,203.78 |
7/9/2012 | 2 | 24,843.50 |
7/10/2012 | 2 | 24,711.19 |
7/3/2012 | 2 | 24,630.80 |
7/4/2012 | 9 | 24,594.51 |
7/4/2012 | 8 | 24,561.19 |
7/5/2012 | 7 | 24,534.53 |
7/6/2012 | 7 | 24,502.24 |
7/9/2012 | 6 | 24,410.81 |
7/7/2012 | 6 | 24,347.97 |
7/3/2012 | 6 | 24,027.44 |
7/2/2012 | 1 | 23,923.56 |
7/3/2012 | 4 | 23,195.19 |
7/9/2012 | 3 | 23,022.71 |
7/5/2012 | 8 | 22,867.72 |
7/4/2012 | 9 | 22,864.61 |
7/5/2012 | 2 | 22,796.41 |
<tbody>
</tbody>
Sheet2
ACCT | 7/2/2012 | 7/3/2012 | 7/4/2012 | 7/5/2012 | 7/6/2012 |
1 | |||||
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | |||||
7 | |||||
8 | |||||
9 |
<tbody>
</tbody>