Excel VBA Basics #19 Using VLOOKUP in VBA - Alternate Method

Learn another approach to VBA worksheet functions - insert an actual VLOOKUP function into a Cell instead of the answer.

Fantastic Developer Tools:

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[gerardvaneggermond]

Hello, the video was interesting, now I have a question if I want to search in another worksheet, how do I do it?

[kyheofarquharson]

I effin love you dude!! I'm new to VBA and I'm trying to impress my boss as no one at our company knows how to use Macro! This will make everyone's lives way easier and hopefully I can push for a THANK YOU 1000

[chonglaipan]

Thx mate
I prefer to use this one as it is easier
Could you tell wt are the benefits of using method 1 or 2??

[ExGod]

hi can u teach how to vlookup from external multiple workbooks from different folder location?it will be very much help full

[cockatielvideos]

Hi Dan, could you please help me out wid a macro to copy data frm one sheet to master sheet using criteria depending on the particular column name from my master sheet, search the column name in other excel and copy that data in that column frm that workbook to master workbook. note the particular required columns may contain spaces in between, hence I am finding it difficult to select data to the end of that column and paste it in master excel. thnks

[ExcelVbaIsFun]

It's pretty easy either way, but if you're beginning, it may be simpler to copy a regular function to VBA editor, rather than doing it in VBA. Not sure the full benefits one way or other. Dan

[stefyuthechosenone]

I follow your videos by practicing directly on my excel workbook and i discovered that the first formulas on vlookup (desc, dadded...) didn't work now even if at the moment i wrote the macro by listening the correspondent videos, everything was alright!!!!
I've tried to put application.volatile prior worsheetfunction, as recommended in a previous comments, but i did'nt work!!!!
Please help!!!
STEPHANE NTONGA from Lille area (FRANCE)

[esmat]

Hi Dan.

For some reason I get a msg box "Run-time error '1004': Application-difined or object-defined error"

My code is as follow:

Sheets("HT").Select
Range("B5").Value = "=VLOOKUP(A1, B2:E3, 2, 0)"

The problem has existed across all of my computers for the last few days. I have made the same code before and it just do not work now. Another odd thing is that if I try to insert a "=" before my formula with a macro then it won't make the replacement if there is a "vlookup" or "if" word in the formula. So I insert a "=" in a formula with macro like: "D2+D3" it then works fine. In addition it wont replace anything in a formula if there is "vlookup" or "if".


I hope for any kind of help.


Thanks in advance.

[redhaakhund]

Am following your great videos and practicing directly. My question is, what if formula is "=IF(B4>TODAY(), "Yes", "No")"? as am getting error on "". Thanks a lot

[ExcelVbaIsFun]

I'd be happy to look at your code. Have you tried downloading the file I'm sharing with everyone through Dropbox? I'll add the link to this description on this video. Try comparing the version I give away free with yours.

[carlosmagellan]

Hi,

I was wandering if the vlookup in vba excel can read this. For example I want to look up this item 0-0, by typing this item 0. Could you give me an example for this. Thanks. karl

[ExcelVbaIsFun]

Cool, Stefyu, what's your question. We'll try to help.

[arne.munther]

Maybe you should had made a look up for the Prop Num as well, so the message would start with BA807 instead of ba807.

Thanks for some great videos.

[awdahle]

Can you put a variable in the column section of the vlookup in vba?  Like "=vlookup(E6, pt_Table, Column(X), 0)" with X in a For loop in VBA?

[stefyuthechosenone]

Thanks you very much for your videos. They are truly great but i've a question.
STEPHANE NTONGA

[ExGod]

it will be better even if external file closed vlookup macro able to do its job