go into VBA and run this code

Sub AddVlookup()
Range("A1").Formula = "=Vlookup(B1,C1:D30,2,False)"
End Sub

then go to A1 on the activesheet and see what the formula looks like.

--
Regards,
Tom Ogilvy

"Christian Bartsch" wrote in message
...
Hi

I am trying to get the vlookup function in excel to work. unfortunately I
am
using a german excel 2002 which doesn't now the name "vlookup".

Does any body know how it might be called in the german or how to use it
even without knowing the german translation??

please send a solution to:

Thanks in advance

Christian