Excel OLAP cube formulas

[sans holo]

I have created an Excel user form that incorporates locked fields that populate with customer information from a SQL server by way of OLAP CUBEVALUE formulas. It works great, however I have run into a problem b/c I have other CUBEMEMBER information that I need to display per user selection which is itself another CUBEMEMBER (Customer ID).

Does anyone know if this is possible and how it might be done?

A fictitious, simplified example of the SQL database would look like the table below. What I would like to show in user form is the "Risk Rating" based on the related "Account #" selected by the user. In Excel speak, it would work like a VLOOKUP or INDEX(MATCH) function.

[TABLE="width: 218"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]"ACCOUNT #" is CUBEMEMBER[/TD]
[TD]"RISK RATING" is CUBEMEMBER[/TD]
[/TR]
[TR]
[TD]AA1
[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]AA2[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]AA3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]AA4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]AA5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD].....[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]