Making certain cells pop up automatically based on a different shett

A

aflores3

i apologize it the title was not descriptive enough, but this is what
i'm trying to do:

on one worksheet, i have my entire price list. The list has 3 colums:
Product number, a product description and a product price.

on a different sheet, i want to be able to type in the product number
and have the respective product description and product price
automatically come up in the next 2 cells.

so far, i got this


Code:
--------------------
=IF(A21='Price Sheet'!A2,'Price Sheet'!C2,IF(A21='Price Sheet'!A3,'Price Sheet'!C3,IF(A21='Price Sheet'!A4,'Price Sheet'!C4,IF(A21='Price Sheet'!A5,'Price Sheet'!C5,IF(A21='Price Sheet'!A6,'Price Sheet'!C6,IF(A21='Price Sheet'!A7,'Price Sheet'!C7,0))))))
--------------------


with A21 being the cell where i'm typing the product number and 'Price
Sheet' Column A being the product number column and C being the product
Description column.

my problem is, I have 500+ products and excel wont allow such a long
formula.

I apologize if this question is elementary... thanks for the help.
 
Top