Vlookup based on multiple criteria

[torooo]

I have 2 workbooks:

Workbook one: Account number, name, January to September + total
(columns A9 to L240)

Workbook two: I need to populate with data from Workbook one
Column A has the account numbers
all accounts that contains department 71(xxxxx-71-xx) must go to
location 1 (Jan - column B, Feb – column E etc)
and all others goes to location 4 (Jan – column C, Feb – column F
etc)
Is there a basic a VLOOKUP or other function that can automatic the
tasks?

Thanks in advance.

Workbook one
Account Number Jan-10 Feb-10 Mar-10
41001-71-01 6,000.00 - 1,000.00
41001-71-03 0 1,000.00 20.00
41002-71-01 462.22 - 30.00
41002-71-02 125.23 6,523.00 70.00
41030-71-01 - - 1,000.00
42001-72-00 54,085.79 - -
46103-76-00 0 12.90
48001-78-00 0 5,000.00
70011-71-03 60,000.00 56,251.00 1,253.00
70011-72-00 1,987.28 4,003.66 6,546.58
70011-73-00 196.70 3,936.13 77.25
70011-74-00 296.53 415.35 226.29
70011-76-00 564.73 534.33 979.29
70011-78-00 32.78 - -


Workbook two

10-Jan 10-Feb 10-Mar
Account Number Location 1 Location 4 Total Location 1 Location 4 Total
Location 1 Location 4 Total

41001-71-01 6,000.00 - 6,000.00 - - -
1,000.00 - 1,000.00
41001-71-03 - - - 1,000.00 - 1,000.00
20.00 - 20.00
41002-71-01 462.22 - 462.22 - - - 30.00
- 30.00
41002-71-02 - - - 6,523.00 - 6,523.00
70.00 - 70.00
41030-71-01 125.23 - 125.23 - - -
1,000.00 - 1,000.00
42001-72-00 - 54,085.79 54,085.79 - - -
- - -
46103-76-00 - - - - - - - 12.90
12.90
48001-78-00 - - - - - - -
5,000.00 5,000.00
70011-71-03 60,000.00 - 60,000.00 56,251.00 -
56,251.00 1,253.00 - 1,253.00
70011-72-00 - 1,987.28 1,987.28 - 4,003.66
4,003.66 - 6,546.58 6,546.58
70011-73-00 - 196.70 196.70 - 3,936.13 3,936.13
- 77.25 77.25
70011-74-00 - 296.53 296.53 - 415.35 415.35
- 226.29 226.29
70011-76-00 - 564.73 564.73 - 534.33 534.33
- 979.29 979.29
70011-78-00 - 32.78 32.78 - - - - -
-