Hi,
Let's say that in Sheet2 you have your data i.e.
George 100
Alan 200
Names are in column A and values in Column B
so in sheet 1 the idea is once entered George in A1 in B1 will retrieve the
value 200
Formula to enter in B1 is

=+VLOOKUP(A3,Sheet2!A:B,2,FALSE)

Where 2 is the column where you need to retrieve the data
hope this help if yes please said yes
"mark3947" wrote:

I would like to create my own worksheet function to do a vlookup. Does
someone have an example that will work?