How to invoke VLookUp function in Excel VBA. [Closed]

Question

How to invoke VLookUp function in Excel VBA. [Closed]

Report

Wingie - Mar 15, 2016 at 05:19 AM
TrowaD

Posts: 2776
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 26, 2021

- Mar 15, 2016 at 12:21 PM

Hello,
Please, I need a visual basic code that can actually invoke or call a V Lookup
function in Excel to query data in two separate worksheets and match same data in each worksheet automatically.

Kind Regards,
Wingie.

How to invoke VLookUp function in Excel VBA.
Search function in excel vba - How-To - Excel
Excel 2007 Using vlookup function in VBA ✓ - Forum - Excel
Excel/VBA - A function that returns the color of an active MFC - How-To - Excel
Excel vba like function - How-To - Excel
Excel vba userform search function ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-03-15T12:21:36-0400

Answer 1 / 1

TrowaD

Posts: 2776
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 26, 2021

465
Mar 15, 2016 at 12:21 PM

Hi Wingie,

When the matrix is located in sheet 2 A1:B5, the value to look up is in sheet1 A1 and the result in sheet1 B1, then the code will look like this:

Sub RunMe()
Sheets("Sheet1").Range("B1").Value = Application.WorksheetFunction. _
VLookup(Sheets("Sheet1").Range("A1"), Sheets("Sheet2").Range("A1:B5"), 2)
End Sub

Best regards,
Trowa

How to invoke VLookUp function in Excel VBA. [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!