IF with LOOKUPVALUE

[Anonymous]

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!!

[Fowmy · Accepted solution]

@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

[Anonymous]

That was it, so simple haha tks!!