I need a (array) formula

[Gillman]

Hi there

I have a template P&L in which I have a hidden column with a unique identifier for each line item that appears. What I need to do is, pull the actual value for each unique line item from a separate Budget file, which is simple if you use a vlookup or sumif. However, I want all of the rows and columns from Jan10-Dec10 to act as a range.

On the P&L template, in Column G9, I have the current month (Jan10). I want to be able to update this so that it’ll automatically pull through the corresponding unique figure based on the month I input into G9.

I think an array formula might be necessary? Below is a sample of the budget file which I am able to restructure if need be:

Jan10 Feb-10 Mar10 Apr10
Unique Identifier
41AA121130100 10 11 15 18
41AA121130150 10 11 15 18
41AA121130605 10 11 15 18
41AA121130700 10 11 15 18
41AA121130810 10 11 15 18
41AA121130820 10 11 15 18
41AA121130821 10 11 15 18


Would anyone please be able to help me?

Cheers,
Darren

 

[DonkeyOte]

for ref. x-posted: http://www.excelforum.com/excel-general/718090-lookup-based-on-two-criteria.html