Populating Cells from other Cells

I have a workbook with 2 sheets. (Excel 2003).

On sheet 1, I have info that looks like this (4 columns):

class1 200 5000 $12,000.00
class2 210 2120 $8900.00

This goes on for 700 classes.

Now, what I'd like to be able to do is, on sheet 2 column A, type in Class1
and have the rest of the data appear (200 5000 $12,000.00). So basically,
I'd like Excel to find in sheet 1 the term CLASS1 and then pull the data in
cells into the other sheet.

If someone could help, I'd appreciate it.

Thanks

You can achieve this with VLOOKUP(), have a look in the help menu on how to
use it.


--
Regards,
Dave


"Nick" wrote:

> I have a workbook with 2 sheets. (Excel 2003).
>
> On sheet 1, I have info that looks like this (4 columns):
>
> class1 200 5000 $12,000.00
> class2 210 2120 $8900.00
>
> This goes on for 700 classes.
>
> Now, what I'd like to be able to do is, on sheet 2 column A, type in Class1
> and have the rest of the data appear (200 5000 $12,000.00). So basically,
> I'd like Excel to find in sheet 1 the term CLASS1 and then pull the data in
> cells into the other sheet.
>
> If someone could help, I'd appreciate it.
>
> Thanks
>