Assigning Cells in worksheets to other data in other worksheets.
 

I think you are looking for the VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

correct spellings (US English): theoretical, theoretically, intentions,
separate, and the word I is always capitalized.

"Rizitsu" wrote ...

Assigning Cells in worksheets to other data in other worksheets.