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:
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:
Any help is more than welcome.