How to perform Vlookup from Closed Workbook

[Kanglese]

Thank you very much. This got me.past a sticking point in my usage. Much appreciated!

[averychen]

I did exactly the same. It does not work. The error message is "Autofill method of range class failed". Have you tested your code?

[averychen]

what is i do not want a range, i want to look up the whole sheet in the other spreadsheet. The range is dynamic?

[ValmisFilm]

cool! But can you do this with VBA formulas? In this example, you create a formula into a cell. But can I use VBA only to get a result into some cell?

[haroldquek]

Hi Sir, how do I have a dynamic range instead?

[accountsferrocast]

thanks for your info but there is no table so its works. if there is some tables how it works?

[TheSawantsKitchen]

Hi Sir,

I've posted one question few months back. I haven't got a resolution yet. It would be great help if you could help me on that.

I wanted to take screen shot of a userform before submitting the data and paste it on outlook 2016 mail body.

Thanks in advance.

[zxcvbnmmasdfghjkl]

How can I do a dynamic countifs or sumifs from closed workbooks?

[valentinavaca]

what if it is excel macro in mac, how can I replace the "C:\"???

[AsifIqbal-lzjv]

Sir, I want to use this method for invoicing to get description and prices for items from closed workbook but I am also getting N/A# for those items not included in my closed workbook. how to remove N/A# error here?

Thank you sir
useful videos
I request vba code how to find multiple lookup of the same case

[Learner]

Sir how to perfrom this with dynemic workbook

[anthonyyeoboren]

hi, can you explain the R2C1 : R2C10 means?

[anupdarade]

Great sir but I have one Question if I want to get multiple value from closed workbook of one value
Ex.suppose A200 this value have many match in closed work book
Such as A200 have two results like
Mouse
Keyboard