I think you are looking for the VLookup funcion
See the Excel help for examples

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dan Gorman" wrote in message ...
I am trying to automatically move data from one cell to another cell
within the same workbook by inputting only the initial figure. Sheet 1
is the worksheet I would like to move the data to and sheet 2 contains
the column of data.

For example:

"If 8810 is entered into one of cells A1 through A10 on sheet 1, then
052 and 2.56 from sheet 2 appear in the corresponding cells in columns
G and H, respectively on sheet 1."

Can this be accomplished in Excel? If so, what is the procedure? What
might be an easy to understand, step-by-step reference to achieve this?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!