• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vba macro for vlookup from another workbook

SPJ

New Member
Hello,

I have 2 Different Workbooks. A & B

In A workbook 5 sheets are there I have consolidated data from 3 sheets on Master sheet . On these 3 sheets From N column onwards there are some number in each row.
Value to these number is available in B workbook which needs to derived by using vlookup

In A workbook on Master sheet in Column U I need Addition of values by vlookup from column N to last column

please guide me to write VBA macro
 
Last edited:

Marc L

Excel Ninja
Hi,​
without the necessary according to this forum rules at least do not forget to​
post your worksheet formulas as after all we are not on any mind readers forum !​
As you can also start your own code just activating the Macro Recorder and operating manually …​

 

SPJ

New Member
sorry Marc
Please find attached file.
There are some numbers written in mixing, filling , packaging sheet from N column onwards . i want to vlookup value for these number from cost workbook, cost sheet. want addition of all these values at once
 

Attachments

Marc L

Excel Ninja
Any sample result ?​
What is the expected result for cell U2, what is your worksheet formula for this cell ?​
 

SPJ

New Member
=VLOOKUP(Mixing!N2,[Attendance.xlsx]Cost!$A$1:$F$61,6,FALSE)*Mixing!J2+++ upto last column in respective sheet
 

Marc L

Excel Ninja
As this formula does not match your initial attachment so the better is to do a new​
attachment with cells filled with formula as it's easier for any helper to check results …​
Maybe you won't need any VBA procedure just using in your formula the INDIRECT worksheet function.​
 
Top