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