Assigning Cells in worksheets to other data in other worksheets.

[Rizitsu]

Assigning Cells in worksheets to other data in other worksheets
(Theoretics)

What my intensions are;

I have a unique identifier in worksheet 1. e.g. 41-01, a concatenatio
of two cells.

I have data corresponding to the unique identifier in worksheet 2, *th
reason's being i needed a unique identifier to relate the data, i hav
seperated textual and numerical data into two worksheets.

Worksheet 1 = Numerical
Worksheet 2 = Textual

through cells "A1:A50" (worksheet 1) i have the unique identifiers
e.g. 41-01
through cells "A1:A50" (worksheet 2) i have the text
e.g. text descriptions of a product.

i want to create an explicit relationship between two worksheets, s
when i later create a form to search for matching records i ca
populate my form with the matching description.

What i am asking for is a solution so that i can assign my uniqu
identifiers to my descriptions?

Thanks in advance. =]

Ri

 

[David McRitchie]

I think you are looking for the VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm


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