Have a lookup table on another sheet in three columns

A product name

B cost price

C retail price

On Sheet1 in D6 enter =VLOOKUP(C6,Sheet2!$A$1:$C$100,2,FALSE)

In E6 enter =VLOOKUP(C6,Sheet2!$A$1:$C$100,3,FALSE)

The A1:C100 is example only. Your range may differ.


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 12:54:12 -0600, Markyboy
wrote:


I have succesfully created a list using Data, Validation option.

This puts the name of the product in the cell C6, but I am trying to
find a way of automatically bringing the cost price of the product into
D6 and the retail price into E6.

I have tried using a string of if statements but after around 10
multiples, it comes up as an error all the time.

Any ideas please

Thanks