Forum Discussion

Epinephrin's avatar
Epinephrin
Regular Visitor
6 years ago
Solved

How can I count the values without VLOOKUP?

Hello everyone,   I would like to check if a value in column A already has any value in column B (no matter which one). Normally I would solve the problem with VLOOKUP:   =IF(VLOOKUP(A1;$A$1:$B$...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Epinephrin ,

     

    Something like below?

    Column = IF('Table'[Column1] in VALUES('Table'[Column2]),"YES","NO")

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Epinephrin ,

 

Something like below?

Column = IF('Table'[Column1] in VALUES('Table'[Column2]),"YES","NO")

 

Best Regards,

Jay