Easy way to get table value with index // VBO

[siema24]

Hi, I'm looking for an easy VBO function that allowes me to get table value. Let me give you an example. I have a simple table tblTeam that consists of:


-index
-name
-surname

and it's filled with data (index/name/surname)
1 / John / Smith
2 / Aaron / Paul
3 / Bryan / Cranston

I need a code that uses input data (3, surname) and gives me value "Cranston".......
function_i_need(3,surname)=Cranston
can you please help me? : ) Thank you so much in advance!

[pbaldy]

Simplest would be DLookup(():

DLookup Usage Samples