Match Value in range with value in another range & output third value -vlookup for ranges?

Hi guys,
I'm new to VBA and have been learning and playing around with various arguments over the past few bays but I still cant get it to do what I want to.
basically I have 3 worksheets -
"Company String Elements" with a 'bank' of string values in column A with altered strings in column B
"Variables page" with a column of drop down selections for all the 'banked' string values from column A on "Company String Elements" sheet
"Output" where I want to produce a list of the altered values (from "Company String Elements" column B) when the banked values on "company string elements" match any of the values selected from the drop down menus on "variables page".
for example - lets say Macdonalds is in A3 of the Company string elements worksheet and if I Select Macdonalds from the "variables page" worksheet drop down and click the button on "output page" I want to see the Altered string value from B3 plus any other matching values from the drop downs.
So far I've managed to get a list of 'altered' strings by using a loop:

Please Login or Register  to view this content.

But this would only work if the drop downs are selected in the same order as they are in-putted on the company string elements worksheet.
so then I had a thought to use just one list with tick boxes and have some kind of IF rule loop but thought this would probably open a huge can of worms.

in an ideal world all of the matching strings would be concatenated but a list that I can then concatenate would be fine.

I hope this makes sense....?
any help would be really appreciated!
Thanks again,
Thom.

From your description, I have no idea what you are trying to do

However, if you have a list of values and their replacement values, you can use Application.WorksheetFunction.VLookup( ... ) in much the same way as you would on a worksheet. The lookup value would be the cell you are processing; the lookup range would be Sheets(" ... ").Range(" ... ") where the sheet and range strings reflect where the lookup table is; and the return column would be 2, with FALSE as the last parameter for an exact match.


Regards, TMS

Thanks for your help TMS,

I probably wasn't clear enough in my description, let me try again.
What I am trying to do it create a search string generator.

What I want to be able to do is select a number of attributes from drop down menu's linked to my "bank" of attributes.
With my 'bank' of attributes I have how these convert to boolean in column B e.g IT would convert to ("Information technology" OR IT OR ICT)

So once I have selected these list of attributes I want something that can match them to the "bank" and produce a list of "search string elements" that can then be put together to give me my overall search string.

Does this make the situation any clearer?

from my understanding of Vlookup it can only match one variable at a time and not a whole list?

apologies if not and thanks again for your support.

Thom.

Descriptive title and tags added by OP. Thanks