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

  • Thread starter Thread starter Derek
  • Start date Start date
D

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.
 
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
 
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
 
Back
Top