Transfer $ of job#/Gl# on 1 s/s to 2nd s/s w/same Job#/Gl# <>coord

[Guest]

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 Phillips]

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)

 

[Guest]

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]

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)