CUBEVALUE - get text from table?

[baseball17bucks]

Hi,

I have a table called tbl_ProjectData that I've queried into the data model of my workbook. Let's say it has two columns. One is "Project ID". One is "Project Description". I want to enter a given Project ID in cell A1 of a worksheet. In cell A2, I want to use a CUBEVALUE function to get the Project Description of the Project ID that I entered in cell A1.

Does anyone know how to do that?

Thanks!

J