Forum Discussion
IF with LOOKUPVALUE
Hi everyone,
Need some help, Im trying to use IF with LOOKUPVALUE, but i always get #ERROR
Client name = IF(Base[Setor de atividade]="RC";LOOKUPVALUE('Base dados mestres'[Nome 1];'Base dados mestres'[Parceiro de negócios];Base[Conta Crédito S4]);LOOKUPVALUE('Base FDK43'[Nome 1];'Base FDK43'[Cliente];Base[Conta de crédito]))
Do you guys know why? Any ideas how i can use that?
Tks!!
Anonymous
Your formula looks okay but check the data types of the columns you are lookup and the source they both need to be in the same data type
2 Replies
- Fowmy
Super User
Anonymous
Your formula looks okay but check the data types of the columns you are lookup and the source they both need to be in the same data type