I am extracting actual costs monthly from P-Tree and mechanically placing
them into an Excel spreadseet by General Ledger # and Job #. Now I want to
extract these $$$ and place them into a permanently designed "Budget vs
Actual Spreadsheet" which has been set up for each job. The variables are
that since the costs differ each month by job and/or general ledger #, no 2
months are the same making the coordinate references different each month.

Is there a formula I can write into the "Budget vs Actuals Spreadsheet" that
will look for matching GL#(Row) and Job # (column) in the spreadsheet of
extracted data and place actual $$$'s into the "Budget vs Actual
Spreadsheet"?

Appreciate Very Much Your Help

The Doc

It sounds as if you want a match on two fields and return an associated
result. That would be something like

=INDEX(Data!$A$2:$N$200,MATCH(row_num,Data!$A$1:$A $200,0),MATCH(cl_num,Data!
$A$1:$N$1,0))

but if you can give example data and expected results, we can be more
precise.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Crowbar" <Dr. wrote in message
...
I am extracting actual costs monthly from P-Tree and mechanically placing
them into an Excel spreadseet by General Ledger # and Job #. Now I want to
extract these $$$ and place them into a permanently designed "Budget vs
Actual Spreadsheet" which has been set up for each job. The variables are
that since the costs differ each month by job and/or general ledger #, no
2
months are the same making the coordinate references different each month.

Is there a formula I can write into the "Budget vs Actuals Spreadsheet"
that
will look for matching GL#(Row) and Job # (column) in the spreadsheet of
extracted data and place actual $$$'s into the "Budget vs Actual
Spreadsheet"?

Appreciate Very Much Your Help

The Doc

Bob,
Thanks for your reply. I could send you abbreviated spreadsheets so you can
better see what I'm trying to accomplish. If OK, pls provide address & I'll
forward to you.
Best Regards and Thank You

"Bob Phillips" wrote:

It sounds as if you want a match on two fields and return an associated
result. That would be something like

=INDEX(Data!$A$2:$N$200,MATCH(row_num,Data!$A$1:$A $200,0),MATCH(cl_num,Data!
$A$1:$N$1,0))

but if you can give example data and expected results, we can be more
precise.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Crowbar" <Dr. wrote in message
...
I am extracting actual costs monthly from P-Tree and mechanically placing
them into an Excel spreadseet by General Ledger # and Job #. Now I want to
extract these $$$ and place them into a permanently designed "Budget vs
Actual Spreadsheet" which has been set up for each job. The variables are
that since the costs differ each month by job and/or general ledger #, no
2
months are the same making the coordinate references different each month.

Is there a formula I can write into the "Budget vs Actuals Spreadsheet"
that
will look for matching GL#(Row) and Job # (column) in the spreadsheet of
extracted data and place actual $$$'s into the "Budget vs Actual
Spreadsheet"?

Appreciate Very Much Your Help

The Doc

Send it to

bob (dot) phillips (at) tiscali (dot) co (dot) uk

do the obvious with the bits in brackets

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Crowbar" wrote in message
...
Bob,
Thanks for your reply. I could send you abbreviated spreadsheets so you
can
better see what I'm trying to accomplish. If OK, pls provide address &
I'll
forward to you.
Best Regards and Thank You

"Bob Phillips" wrote:

It sounds as if you want a match on two fields and return an associated
result. That would be something like


=INDEX(Data!$A$2:$N$200,MATCH(row_num,Data!$A$1:$A $200,0),MATCH(cl_num,Data!
$A$1:$N$1,0))

but if you can give example data and expected results, we can be more
precise.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Crowbar" <Dr. wrote in message
...
I am extracting actual costs monthly from P-Tree and mechanically
placing
them into an Excel spreadseet by General Ledger # and Job #. Now I
want to
extract these $$$ and place them into a permanently designed "Budget
vs
Actual Spreadsheet" which has been set up for each job. The variables
are
that since the costs differ each month by job and/or general ledger #,
no
2
months are the same making the coordinate references different each
month.

Is there a formula I can write into the "Budget vs Actuals
Spreadsheet"
that
will look for matching GL#(Row) and Job # (column) in the spreadsheet
of
extracted data and place actual $$$'s into the "Budget vs Actual
Spreadsheet"?

Appreciate Very Much Your Help

The Doc