Post a small sample of the data on sheet2.

Add a small sample of the type of lookup value.

Show the VLOOKUP formula you have tried.

Example....................

Sheet2 columns A and B have names in A and descriptions in B

In Sheet1 you have a name in A1.

In B1 enter =VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE)

Returns the description from column B which matches the name in column A


Gord Dibben MS Excel MVP


On Thu, 15 Oct 2009 14:59:01 -0700, Derek
wrote:

I am trying to create a spreadsheet that allows a user to enter data then the
columns next the the entered data will populate based upon what was enter. I
have tried vlookup but it only returns the value that matches the column
which is the wrong data. Please help.