vlookup function in excel

  • Thread starter Thread starter Christian Bartsch
  • Start date Start date
C

Christian Bartsch

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: (e-mail address removed)

Thanks in advance

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