Hi
I have a workbook (salesdata.xls) which contains sales information for a full year by department, it looks like this:
<tbody>
</tbody>
On a separate workbook (depts.xls) I want to pull information by department for a specific week, like this:
<tbody>
</tbody>
I need the sheet to be able to pull the sales for that department for the week specified.
I know how to use VLOOKUP to pull this information using a formula for a specific row or cell, but I don't know how to pull the information based on the value of the week (which would be in cell B3 in the example above). Therefore when I change the week number (in B3 above) to 5 the sales in cell C3 would show 230.
Hope this is clear. Thanks in advance for any help.
I have a workbook (salesdata.xls) which contains sales information for a full year by department, it looks like this:
Week | Dept A | Dept B | Dept C | Dept D | Dept E | Dept F | Dept G |
Week 1 | 700 | 520 | 100 | 620 | 44 | 120 | 800 |
Week 2 | 125 | 522 | 144 | 800 | 55 | 170 | 700 |
Week 3 | 122 | 400 | 200 | 120 | 44 | 150 | 500 |
Week 4 | 100 | 350 | 180 | 100 | 70 | 190 | 600 |
Week 5 | 230 | 400 | 158 | 164 | 80 | 170 | 500 |
<tbody>
</tbody>
On a separate workbook (depts.xls) I want to pull information by department for a specific week, like this:
Dept A | Sales | |
Week Number: | 4 | 100 |
<tbody>
</tbody>
I need the sheet to be able to pull the sales for that department for the week specified.
I know how to use VLOOKUP to pull this information using a formula for a specific row or cell, but I don't know how to pull the information based on the value of the week (which would be in cell B3 in the example above). Therefore when I change the week number (in B3 above) to 5 the sales in cell C3 would show 230.
Hope this is clear. Thanks in advance for any help.