VBA cell content from another workbook

[ThomasOES]

I want to import the calcium value of sample NIST 1254 from a database in workbook "GDSCRM", Sheet1; to workbook "report" range "cert".
The workbook "report" needs the macro.
The database in workbook "GDSCRM" has thousands of entries. All the names are in column A. The top row of the sheet has the list of elements (Ex. C, S, Mg, Ca) beginning in column B.
So I would want to search column A for NIST 1254, then the row with the NIST 1254 for the value in the column labeled Ca.

Thanks
Tom

 

[ThomasOES]

I was able to use the recorder and pieced together this code
Range "MonVal" is the Calcium content of sample NIST 1254
"MonVal" is a named cell

in a workbook titled "E826 Study".​

The database is in the workbook GDSCRM.xlsx
Sheet1
The entire database is in the range A1:AD2000
"MonName" is a named cell in a workbook titled "E826 Study". In this instance the sample NIST 1254 is entered into the cell named "MonName"
The list of sample names is in column A

in the workbook GDSCRM.xlsx​

"El" is a named cell

in a workbook titled "E826 Study"​

. In this instance the symbol for calcium "Ca" is entered into the cell named "El"
The list of elements is in row 1

in the workbook GDSCRM.xlsx​

Range("MonVal") = _
        "=INDEX([GDSCRM.xlsx]Sheet1!$A$1:$AD$2000,MATCH(MonName,[GDSCRM.xlsx]Sheet1!$A$1:$A$2000,0),MATCH(El,[GDSCRM.xlsx]Sheet1!$A$1:$BZ$1,1))"