Multiple IF conditions?

[Stuck Again]

I have experiement with a a few formulas, but have been
unable to find one to do what I require.

The spreadsheet consists of 2 worksheets.

Sheet 1 allows the user to enter in data on a "unit"

ie:

# Name Price
1 Quacky $4.00
2 Yub Yub $5.00
etc

Sheet 2 is basically a summary sheet of "sales"
transactions of the units as indicated on Sheet 1. (note:
each unit has a seperate serial #)

Serial# Name Price
132424 Quacky $4.00
132555 Quacky $4.00
555666 Yub Yub $5.00
etc

What I want to do is to add a "item #" column on Sheet
that will automatically input the info on the unit. So if
someone types "1" in the "item #" column, it will
automatically pull in the Name and Price for Quacky.

Ideally I need an IF/ELSE statement:

ie
IF item# = 1 then display values for "1" as declared on
Sheet1
IF item# = 2 then display values for "2" as declared on
Sheet1
etc

Is this possible? I've tried a few experiments but can
not find a way to do this.

 

[J.E. McGimpsey]

One way:

You would be better off using a VLOOKUP command - If's can be nested
only 7 deep.

A1: Item #
A2: 1

B2: =VLOOKUP(A2, Sheet1!A:C, 2, 0) ==> Quacky
C2: =VLOOKUP(A2, Sheet1!A:C, 3, 0) ==> $4.00