Hello, can you please help me with formula something similar to vlookup?
Trying to fill in the Division property using the Department code dimension.
Tried using “ITEM('PL GL Data'.Department,'Department Code'.'Department Name')”, but error says
“ Error: Expressions are incompatible and cannot all be converted to Dimension (Department Code)”
Thanks in advance!
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/3b137fb3-de61-45b3-ab45-a4832bd5d0a8.png)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/9b320224-e442-43ed-9d4a-13a99d3d6e2e.png)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/44b91c5b-6cd9-4637-85f3-96884435804d.png)