how do I connect data between 2 worksheets

M

Mich

I have to worksheets with in an Excel file. I want the 1st sheet to
pick up informaion from the 2nd sheet which is the description page.

I only want to key the number on page one and the description be
automatically read from the 2nd page. example

when I key 504319095 I want the description column and the size column
to pick up "red" and "small" from the second page.

I have inserted formulas before, but never for data always for
numbers.

Thanks for your help

Mich.

Hoping this is clear enough
 
Top