Hi!

I'm new here, so please bare with me, if I make some mistakes.

OS: Win 7 pro

Excel: Excel 2010 Beta

I have 4 seperate drop down lists with input needed to determine the production of a PV system: Location, orientation, tilt and plant size.

I would like to concatenate these 4 inputs, and look for a match value in a column.

To give an example:

Drop-down inputs:

B4 = Copenhagen

B6 = South

B8 = 40 degrees

B10 = 3,8kW

This should be concatenated into "CopenhagenSouth40degrees3,8kW". Then the function should look in column N to find a exact match of this string.

Column N contains the parameters (Selected from the dropdown lists), and column Q contains the production of the PV system (3.640 kWh in this case)

As a final thing, I would like the function to return the value from the Q column.

Is this possible?

I have tried with the following functions:

{=MATCH(CONCATENATE(B4;B6;B8;B10);A18:A30)}

and

{=VLOOKUP(CONCATENATE(B4;B6;B8;B10);A18:A30;1)}

Any help is more than welcome.

//Kasper