Enter Data on one tab, then find matching data on another tab
 

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.

Enter Data on one tab, then find matching data on another tab
 

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.

Enter Data on one tab, then find matching data on another tab
 

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.