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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup function in excel doesn't work in the german version - translation name? 2
VBA userform Vlookup Excel 1
Converting workbook to run on German excel 6
Vlookup Function 1
Put a formula to a cell with macro and it doesent calculate. (Excel localisation problem?) 1
Custom function for vlookup 11
VLOOKUP 2
Nested If Function to be converted into a user-defined customfunction 1

Back
Top