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.