Hi,

We are using an application that creates a spreadsheet when doing a search in a database. Let us call this spreadsheet autocreated.xls.
Today we have to complete this spreadsheet manually by using a reference guide excel spreadsheet. Let us call this fixed.xls.

Problem:
To complete this autocreated.xls with text and values we manually have to copy and paste this information from the fixed.xls spreadsheet.
We would like to atomate this.

Question:
In a spreadsheet, is there a command-line one can type in a cell to trigger a search in another workbook to find a datavalue and when found the command-line continues to collect other text or data from another cell on the same row?

For example, we need a command-line to...
Find value 44150 in column A in fixed.xls and collect text from the D column on the same row as 44150.

Thanks in advance!
True