I wanted to use a lookup to return not a value in a single cell if an ID
matches, but an entire row of fields that belong to that ID from another
workbook.

Example,

If an ID matches in Workbook 1 then return row 3 (assuming the ID is in that
row),
which runs from colum A thru AJ from workbook 2.