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

[Derek]

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.

 

[Gord Dibben]

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

 

[Jacob Skaria]

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,3,0)

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


If this post helps click Yes