You can check out:

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

Hope this helps.


Juan wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200903/1