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.

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.

VLOOKUP() can do this. To return the value from Column 3 of sheet2 for a
mathching value in ColA

'returns from ColC
=VLOOKUP("derek",Sheet2!A:D,3,0)

'returns from column F
=VLOOKUP("derek",Sheet2!D:F,3,0)


If this post helps click Yes
---------------
Jacob Skaria


"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.