Making certain cells pop up automatically based on a different shett

D

drabbacs

You want to do a VLOOKUP.

Assuming the source data is on Price Sheet in columns A,
B, and C from row 1 to 500 and on Sheet2 you are typing
the product number in column A, then in Sheet2!B21 type
this:

=VLOOKUP(A21,'Price Sheet'!$A$1:$C$500,2,"false")

in C1

=VLOOKUP(A21,'Price Sheet'!$A$1:$C$500,3,"false")

copy the formula down as far as necessary.

A21: Where you want to type the part numbers in.
'Price Sheet'!$A$1:$C$500 :where the source data resides

2: second column
3: third column

Good Luck

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

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:
Click to expand...
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))))))
Click to expand...
 
Top