How to create formula IF with ISBLANC and LOOKUP

[olivkalivka]

Hi,

Is it possible to create below formula in PBI?

=IF(OR(G8="A";G8="B");IF(ISBLANK(T8);"C";"D");VLOOKUP(G8;Matrix!A:B;2;0))

Thanks in advance

[Anonymous · Accepted solution]

Hi @olivkalivka,

If you formula not contains any function who request value from specific cell, I think it is possible.

Calculate column formula:

LookUP =
IF (
    OR ( Table[G] = "A"; Table[G] = "B" );
    IF ( Table[T] = BLANK() ; "C"; "D" );
    LOOKUPVALUE ( Matrix[B]; Matrix[A]; Table[G] )
)

Regards,

Xiaoxin Sheng