Lookup Function

[Juan]

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.

 

[Chin via OfficeKB.com]

You can check out:

http://www.cpearson.com/Excel/TablesAndLookups.aspx

Hope this helps.