Vlookup in VBA

Resolved · Medium Priority · Version 2007

Tue 10 Jun 2014, 12:15 Delegate Susanna said...

Susanna has attended:
Excel VBA Intro Intermediate course
Taking Minutes course
Excel VBA Advanced course
Excel PowerPivot course

Vlookup in VBA

I don't manage to make VLookUp function work in VBA, when working with 2 different excel files. I have tried at least 5 or 6 different suggestion found on Internet, with no positive result. I can send the file with the code and the data if you give me an e-mail address.
Thanks a lot,
Susanna

Tue 10 Jun 2014, 12:43 Trainer Jens said...

RE: Vlookup in VBA

Hi Susanna,

Thank you for the forum question.

Yes please send me the file, so I can see what you want to do.

Please forward the file to:

info@stl-training.co.uk

Please add my name to the subject.

Thanks

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu

Tue 10 Jun 2014, 14:18 Trainer Jens said...

RE: Vlookup in VBA

Hi Susanna,

Please change the variable OrdNum from string to long:

Dim OrdNum As Long

This is the only thing you need to do to make it work.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu

Thu 12 Jun 2014, 11:46 Delegate Susanna said...

RE: Vlookup in VBA

Hi Jens,

it does work, thanks a lot!!!!!!!!!!!! So simple the solution, and I did not find it (or see it) in all my searchs in the Internet. So much time lost :-(!!!

Thanks a lot again,

Susanna

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:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips