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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top