Hi
have a look at the VLOOKUP function. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"util" schrieb im Newsbeitrag
...
How do you combine information from two worksheets..First worksheet
is the
main worksheet. One field in the row determines the information to
pull from
the second worksheet. If the Field idatas matches the field data in
the
second worksheet...... the entire row should be linked to first
worksheet row.