Problem with calc multiple vlookup plugin

[mamboze]

I have 2 spreadsheets, each containing a set of words,Set A and Set B. I want to find out how many words in Set B are also in Set A.

I installed the “Multiple values from vlookup” plugin from
http:// www. debugpoint.com/2014/12/libreoffice-calc-macro-multiple-values-from-vlookup-result/

I followed the how-to-use instructions placing each set in the one spreadsheet as set out on the page. but I couldn’'t see how to invoke the plugin. Presumably, the 2 sets are sent as arguments in some way, but how? or am I completely out of the ball park here. Any suggestions would be very welcome.

(defanged possible spam)

[nicholas]

Mamboze, that link did not say to install any plugin. It refers to a question from Stackoverflow.

Look like this is a click-bait, or you are not familiar with macros.

The instruction requires you to add the provided code as a macro. Then click any remainder empty cell and run the macro to provide the calculation.

Here is the macro that works with data at area A2:B4 and A8:A15.

Dim row1, row2, row3, prod_img_str
row3 = 6
' loop through all the products
for row1 = 1 to 3
	' hold the product id and name
	prod_id = ThisComponent.Sheets(0).getCellbyPosition(0,row1)
	prod_nm =  ThisComponent.Sheets(0).getCellbyPosition(1,row1)
	' loop through the image list
	for row2 = 7 to 15
		prod_img = ThisComponent.Sheets(0).getCellbyPosition(0,row2)
		' if matched product list found hold the value
		if prod_id.Value = Mid(prod_img.String,1,3) then
			prod_img_str = prod_img_str & prod_img.String & ","				
		end if
	next
	' put the result value
	result =  ThisComponent.Sheets(0).getCellbyPosition(2,row3)
	result.Value = prod_id.Value
 
	result = ThisComponent.Sheets(0).getCellbyPosition(3,row3)
	result.String = prod_nm.String
 
	result = ThisComponent.Sheets(0).getCellbyPosition(4,row3)
	result.String = prod_img_str
	prod_img_str = ""			
	row3 = row3 + 1
 
Next