Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

ResolvedVersion 2003

Wed 30 Jul 2008, 16:28 Delegate De said...

De has attended:
Excel VBA Intro Intermediate course

VBA

Can I use a vlookup type function in VBA.

Fri 1 Aug 2008, 11:16 Trainer Carlos said...

Lookup function in VBA

Hi

The simple answer is Yes.

You need to create a variable to store the lookup value. The variable type must equal the type of data being returned.

The code would be:

Dim MyLookupValue As [Type]

MyLookupValue = Application.WorksheetFunction.VLookup(LookUp_Value, Table_Array, Col_index_num, Range_Lookup)

Hope this helps

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

VBA

VBA

Lookup function in VBA

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel