Writing a VLOOKUP function in vba

by

Have you tried:

Dim result As String 
Dim sheet As Worksheet 
Set sheet = ActiveWorkbook.Sheets("Data") 
result = Application.WorksheetFunction.VLookup(sheet.Range("AN2"), sheet.Range("AA9:AF20"), 5, False)

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Sequence of numbers based on start and end value of 2 cells [closed]
  3. Function to convert column number to letter?
  4. Read/Parse text file line by line in VBA
  5. Better way to find last used row
  6. Excel VBA: Answer gets “stuck”
  7. 2 Dimensional array from range [closed]
  8. filter out multiple criteria using excel vba
  9. Excel VBA autofilter all but three
  10. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  11. Using Google Chrome in Selenium VBA (Installation Steps)
  12. Dir() function not working in Mac Excel 2011 VBA
  13. Excel VBA code to copy a specific string to clipboard
  14. How to use workbook.saveas with automatic Overwrite
  15. Range limit conundrum
  16. How do you run a .exe with parameters using vba’s shell()?
  17. Excel VBA – Range.Copy transpose paste
  18. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  19. How do you get a Range to return its Name?
  20. Passing variable from Form to Module in VBA
  21. Excel VBA: Convert a date string to a Unix timestamp
  22. excel to pdf ignores print area and calls printer
  23. In Excel, can I use a hyperlink to run vba macro?
  24. Excel VBA – exit for loop
  25. Macro to export MS Word tables to Excel sheets
  26. VBA WinHTTP to download file from password proteced https website
  27. Create folder path if does not exist (saving from VBA)
  28. Access files with long paths (over 260)
  29. Concatenate multiple ranges using vba
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment