Add values in one data table by looking values from another data table

Capture

I have 2 data table as depicted in the image. I want to make a new data table wherein i lookup a value from dt2 and look it up in dt1 to extract corresponding values and paste it in 3rd datatable as depicted in the image above.

How do i go about doing this

This should give you an idea
image
It will loop through two datatables and if a match is found in col1, col2 values will be pasted in the next table. You will need another loop to accomodate 3 tables. This might take time if data is large.

You can also setup a macro with vlookup formula

Thanks a ton. :smiley: … this worked

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.